autocreatecode.cs

一款自动编码工具

			//					type	= dt.Rows[i5]["type_name"].ToString();
			//				}
			//				sw.WriteLine("			objlrTable.Set{0}(Convert.To{1}{2}(txt_{3}.Text));",dt.Rows[i5]["column_name"].ToString(),type.ToString().Substring(0,1).ToUpper(),type.Substring(1,type.Length-1),dt.Rows[i5]["column_name"].ToString());
			//			}
			//			sw.WriteLine("			}");
			//			sw.WriteLine("\r");
			//
			//
			//			sw.WriteLine("			///btnSearch_Click");
			//			sw.WriteLine("			{");
			//			for(int i6=0;i6<dt.Rows.Count;i6++)
			//			{
			//				sw.WriteLine("			txt_{0}.Text		= objlrView.Get{1}().ToString();",dt.Rows[i6]["column_name"].ToString(),dt.Rows[i6]["column_name"].ToString());
			//			}
			//			sw.WriteLine("			}");
			//			sw.WriteLine("\r");
			//
			//			for(int i7=0;i7<dt.Rows.Count;i7++)
			//			{
			//				sw.Write("sum({0}) as {1}1,",dt.Rows[i7]["column_name"].ToString(),dt.Rows[i7]["column_name"].ToString());
			//			}
			//			sw.WriteLine("			}");
			//			sw.WriteLine("\r");
			//
			//			for(int i8=0;i8<dt.Rows.Count;i8++)
			//			{
			//				sw.WriteLine("			if (objZcsyView.Get{0}()!=-1)",dt.Rows[i8]["column_name"].ToString());
			//				sw.WriteLine("					txt_{0}_sum.Text			= objZcsyView.Get{1}().ToString();",dt.Rows[i8]["column_name"].ToString(),dt.Rows[i8]["column_name"].ToString());
			//				sw.WriteLine("\r");
			//			}
			
			sw.Write("\n");
			sw.WriteLine("	}");
			sw.WriteLine("}");		
			sw.Close();


			FileStream fs = File.Open(Application.StartupPath+@"\DA"+tableName+"Table.cs",FileMode.Open);
			StreamReader sr = new StreamReader(fs);
			this.richTextBox.Text = sr.ReadToEnd();
			sr.Close();
		}

	

		private void menuItem2_Click(object sender, System.EventArgs e)
		{
			config configfrm = new config();
			configfrm.ShowDialog();
		}

	

		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			this.DBTreeView.Nodes.Clear();
			LoadData();
		}

		private void DBTreeView_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
		{
			if( this.DBTreeView.SelectedNode.Parent != null )
			{
				this.txttabname.Text = this.DBTreeView.SelectedNode.Text;	
			}
		}

		private void cut_Click(object sender, System.EventArgs e)
		{
			this.richTextBox.Cut();
		}

		private void Copy_Click(object sender, System.EventArgs e)
		{
			this.richTextBox.Copy();
		}

		private void Paste_Click(object sender, System.EventArgs e)
		{
			this.richTextBox.Paste();
		}

		private void Del_Click(object sender, System.EventArgs e)
		{
			this.richTextBox.SelectedText = "";
		}

		#region Sql类型转换
		/// <summary>
		/// 将字符串描述的参数类型转换为Sql参数类型
		/// </summary>
		/// <param name="strparamType">字符串描述的参数类型</param>
		/// <param name="paramType">输出Sql参数类型</param>
		/// <returns></returns>
		private int Getparam(string strparamType,out SqlDbType paramType)
		{
			
			int result=0;
			paramType=SqlDbType.Int;
			if(SqlDbType.BigInt.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.BigInt;
				return result;
			}
			if(SqlDbType.Binary.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Binary;
				return result;
			}
			if(SqlDbType.Bit.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Bit;
				return result;
			}
			if(SqlDbType.Char.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Char;
				return result;
			}
			if(SqlDbType.DateTime.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.DateTime;
				return result;
			}
			if(SqlDbType.Decimal.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Decimal;
				return result;
			}
			if(SqlDbType.Decimal.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Decimal;
				return result;
			}
			if(SqlDbType.Float.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Float;
				return result;
			}
			if(SqlDbType.Image.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Image;
				return result;
			}
			if(SqlDbType.Int.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Int;
				return result;
			}
			if(SqlDbType.Money.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Money;
				return result;
			}
			if(SqlDbType.NChar.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.NChar;
				return result;
			}
			if(SqlDbType.NText.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.NText;
				return result;
			}
			if(SqlDbType.NVarChar.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.NVarChar;
				return result;
			}
			if(SqlDbType.Real.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Real;
				return result;
			}
			if(SqlDbType.SmallDateTime.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.SmallDateTime;
				return result;
			}
			if(SqlDbType.SmallInt.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.SmallInt;
				return result;
			}
			if(SqlDbType.SmallMoney.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.SmallMoney;
				return result;
			}
			if(SqlDbType.Text.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Text;
				return result;
			}
			if(SqlDbType.Timestamp.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Timestamp;
				return result;
			}
			if(SqlDbType.TinyInt.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.TinyInt;
				return result;
			}
			if(SqlDbType.UniqueIdentifier.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.UniqueIdentifier;
				return result;
			}
			if(SqlDbType.VarBinary.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.VarBinary;
				return result;
			}
			if(SqlDbType.VarChar.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.VarChar;
				return result;
			}
			if(SqlDbType.Variant.ToString().ToUpper().CompareTo(strparamType)==0)
			{
				paramType=SqlDbType.Variant;
				return result;
			}

			return -1;
		}
		/// <summary>
		/// 数据库中与C#中的数据类型对照
		/// </summary>
		/// <param name="type"></param>
		/// <returns></returns>
		private string ChangeToCSharpType(string type)
		{
			string reval=string.Empty;
			switch(type.ToLower())
			{
				case "int":
					reval= "int";
					break;
				case "text":
					reval= "text";
					break;
				case "bigint":
					reval= "int64";
					break;
				case "binary":
					reval= "System.Byte[]";
					break;
				case "bit":
					reval= "bool";
					break;
				case "char":
					reval= "string";
					break;
				case "datetime":
					reval= "DateTime";
					break;	
				case "decimal":
					reval= "decimal";
					break;
				case "float":
					reval= "double";
					break;
				case "image":
					reval= "System.Byte[]";
					break;
				case "money":
					reval= "decimal";
					break;
				case "nchar":
					reval= "string";
					break;
				case "ntext":
					reval= "string";
					break;
				case "numeric":
					reval= "decimal";
					break;
				case "nvarchar":
					reval= "strings";
					break;
				case "real":
					reval= "System.Single";
					break;
				case "smalldatetime":
					reval= "System.DateTime";
					break;
				case "smallint":
					reval= "Int16";
					break;
				case "smallmoney":
					reval= "System.Decimal";
					break;
				case "timestamp":
					reval= "System.DateTime";
					break;
				case "tinyint":
					reval= "System.Byte";
					break;
				case "uniqueidentifier":
					reval= "System.Guid";
					break;
				case "varbinary":
					reval= "System.Byte[]";
					break;
				case "varchar":
					reval= "string";
					break;
				case "Variant":
					reval="object";
					break;
				default:
					reval= "string";
					break;
			}
			return reval;
		} 

		#endregion

	}
}