/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Add(yny_005.Model.C_CarTast model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into C_CarTast("); strSql.Append("Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,OCode,CSpare2,ComDate,XSMID,DDMID,Prot)"); strSql.Append(" values ("); strSql.Append("@Name,@TType,@SupplierName,@SupplierAddress,@SupplierTelName,@SupplierTel,@CarID,@CarSJ1,@CarSJ2,@CostType,@BDImg,@TState,@IsDelete,@Spare1,@Spare2,@OCode,@CSpare2,@ComDate,@XSMID,@DDMID,@Prot)"); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 150), new SqlParameter("@TType", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 50), new SqlParameter("@SupplierAddress", SqlDbType.VarChar, 150), new SqlParameter("@SupplierTelName", SqlDbType.VarChar, 50), new SqlParameter("@SupplierTel", SqlDbType.VarChar, 50), new SqlParameter("@CarID", SqlDbType.Int, 4), new SqlParameter("@CarSJ1", SqlDbType.VarChar, 50), new SqlParameter("@CarSJ2", SqlDbType.VarChar, 50), new SqlParameter("@CostType", SqlDbType.Int, 4), new SqlParameter("@BDImg", SqlDbType.VarChar, 250), new SqlParameter("@TState", SqlDbType.Int, 4), new SqlParameter("@IsDelete", SqlDbType.Int, 4), new SqlParameter("@Spare1", SqlDbType.VarChar, 250), new SqlParameter("@Spare2", SqlDbType.VarChar, 250), //new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@OCode", SqlDbType.VarChar, 50), new SqlParameter("@CSpare2", SqlDbType.VarChar, 50), new SqlParameter("@ComDate", SqlDbType.DateTime), new SqlParameter("@XSMID",SqlDbType.VarChar,50), new SqlParameter("@DDMID", SqlDbType.VarChar, 50), new SqlParameter("@Prot", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.TType; parameters[2].Value = model.SupplierName; parameters[3].Value = model.SupplierAddress; parameters[4].Value = model.SupplierTelName; parameters[5].Value = model.SupplierTel; parameters[6].Value = model.CarID; parameters[7].Value = model.CarSJ1; parameters[8].Value = model.CarSJ2; parameters[9].Value = model.CostType; parameters[10].Value = model.BDImg; parameters[11].Value = model.TState; parameters[12].Value = model.IsDelete; parameters[13].Value = model.Spare1; parameters[14].Value = model.Spare2; //parameters[15].Value = model.CreateDate; parameters[15].Value = model.OCode; parameters[16].Value = model.CSpare2; parameters[17].Value = model.ComDate; parameters[18].Value = model.XSMID; parameters[19].Value = model.DDMID; parameters[20].Value = model.Prot; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
public static Model.C_CarTast GetModelBySJ(string mid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,CreateDate,OCode,CSpare2,ComDate,XSMID,DDMID,Prot from C_CarTast "); strSql.AppendFormat(" where (CarSJ1='{0}' or CarSJ2='{0}') and TState=0;", mid); yny_005.Model.C_CarTast model = new yny_005.Model.C_CarTast(); DataSet ds = DbHelperSQL.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static yny_005.Model.C_CarTast GetModelname(string name) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,CreateDate,OCode,CSpare2,ComDate,XSMID,DDMID,Prot from C_CarTast "); strSql.Append(" where Name=@Name"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 50) }; parameters[0].Value = name; yny_005.Model.C_CarTast model = new yny_005.Model.C_CarTast(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public static int Add(yny_005.Model.C_CarTast model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into C_CarTast("); strSql.Append("Name,TType,SupplierName,SupplierAddress,SupplierTelName,SupplierTel,CarID,CarSJ1,CarSJ2,CostType,BDImg,TState,IsDelete,Spare1,Spare2,OCode,CSpare2,ComDate,XSMID,DDMID,Prot)"); strSql.Append(" values ("); strSql.Append("@Name,@TType,@SupplierName,@SupplierAddress,@SupplierTelName,@SupplierTel,@CarID,@CarSJ1,@CarSJ2,@CostType,@BDImg,@TState,@IsDelete,@Spare1,@Spare2,@OCode,@CSpare2,@ComDate,@XSMID,@DDMID,@Prot)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 150), new SqlParameter("@TType", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 50), new SqlParameter("@SupplierAddress", SqlDbType.VarChar, 150), new SqlParameter("@SupplierTelName", SqlDbType.VarChar, 50), new SqlParameter("@SupplierTel", SqlDbType.VarChar, 50), new SqlParameter("@CarID", SqlDbType.Int, 4), new SqlParameter("@CarSJ1", SqlDbType.VarChar, 50), new SqlParameter("@CarSJ2", SqlDbType.VarChar, 50), new SqlParameter("@CostType", SqlDbType.Int, 4), new SqlParameter("@BDImg", SqlDbType.VarChar, 250), new SqlParameter("@TState", SqlDbType.Int, 4), new SqlParameter("@IsDelete", SqlDbType.Int, 4), new SqlParameter("@Spare1", SqlDbType.VarChar, 250), new SqlParameter("@Spare2", SqlDbType.VarChar, 250), //new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@OCode", SqlDbType.VarChar, 50), new SqlParameter("@CSpare2", SqlDbType.VarChar, 50), new SqlParameter("@ComDate", SqlDbType.DateTime), new SqlParameter("@XSMID",SqlDbType.VarChar,50), new SqlParameter("@XSMID", SqlDbType.VarChar, 50), new SqlParameter("@Prot", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.TType; parameters[2].Value = model.SupplierName; parameters[3].Value = model.SupplierAddress; parameters[4].Value = model.SupplierTelName; parameters[5].Value = model.SupplierTel; parameters[6].Value = model.CarID; parameters[7].Value = model.CarSJ1; parameters[8].Value = model.CarSJ2; parameters[9].Value = model.CostType; parameters[10].Value = model.BDImg; parameters[11].Value = model.TState; parameters[12].Value = model.IsDelete; parameters[13].Value = model.Spare1; parameters[14].Value = model.Spare2; //parameters[15].Value = model.CreateDate; parameters[15].Value = model.OCode; parameters[16].Value = model.CSpare2; parameters[17].Value = model.ComDate; parameters[18].Value = model.XSMID; parameters[19].Value = model.DDMID; parameters[20].Value = model.Prot; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public static yny_005.Model.C_CarTast DataRowToModel(DataRow row) { yny_005.Model.C_CarTast model = new yny_005.Model.C_CarTast(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["TType"] != null && row["TType"].ToString() != "") { model.TType = int.Parse(row["TType"].ToString()); } if (row["SupplierName"] != null) { model.SupplierName = row["SupplierName"].ToString(); } if (row["SupplierAddress"] != null) { model.SupplierAddress = row["SupplierAddress"].ToString(); } if (row["SupplierTelName"] != null) { model.SupplierTelName = row["SupplierTelName"].ToString(); } if (row["SupplierTel"] != null) { model.SupplierTel = row["SupplierTel"].ToString(); } if (row["CarID"] != null && row["CarID"].ToString() != "") { model.CarID = int.Parse(row["CarID"].ToString()); } if (row["CarSJ1"] != null) { model.CarSJ1 = row["CarSJ1"].ToString(); } if (row["CarSJ2"] != null) { model.CarSJ2 = row["CarSJ2"].ToString(); } if (row["CostType"] != null && row["CostType"].ToString() != "") { model.CostType = int.Parse(row["CostType"].ToString()); } if (row["BDImg"] != null) { model.BDImg = row["BDImg"].ToString(); } if (row["TState"] != null && row["TState"].ToString() != "") { model.TState = int.Parse(row["TState"].ToString()); } if (row["IsDelete"] != null && row["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(row["IsDelete"].ToString()); } if (row["Spare1"] != null) { model.Spare1 = row["Spare1"].ToString(); } if (row["Spare2"] != null) { model.Spare2 = row["Spare2"].ToString(); } if (row["CreateDate"] != null) { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["OCode"] != null) { model.OCode = row["OCode"].ToString(); } if (row["CSpare2"] != null) { model.CSpare2 = row["CSpare2"].ToString(); } if (row["ComDate"] != null) { model.ComDate = DateTime.Parse(row["ComDate"].ToString()); } if (row["XSMID"] != null) { model.XSMID = row["XSMID"].ToString(); } if (row["DDMID"] != null) { model.DDMID = row["DDMID"].ToString(); } if (row["Prot"] != null && row["Prot"].ToString() != "") { model.Prot = int.Parse(row["Prot"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(yny_005.Model.C_CarTast model, Hashtable MyHs) { StringBuilder strSql = new StringBuilder(); strSql.Append("update C_CarTast set "); strSql.Append("Name=@Name,"); strSql.Append("TType=@TType,"); strSql.Append("SupplierName=@SupplierName,"); strSql.Append("SupplierAddress=@SupplierAddress,"); strSql.Append("SupplierTelName=@SupplierTelName,"); strSql.Append("SupplierTel=@SupplierTel,"); strSql.Append("CarID=@CarID,"); strSql.Append("CarSJ1=@CarSJ1,"); strSql.Append("CarSJ2=@CarSJ2,"); strSql.Append("CostType=@CostType,"); strSql.Append("BDImg=@BDImg,"); strSql.Append("TState=@TState,"); strSql.Append("IsDelete=@IsDelete,"); strSql.Append("Spare1=@Spare1,"); strSql.Append("Spare2=@Spare2,"); //strSql.Append("CreateDate=@CreateDate,"); strSql.Append("OCode=@OCode,"); strSql.Append("CSpare2=@CSpare2,"); strSql.Append("ComDate=@ComDate,"); strSql.Append("XSMID=@XSMID,"); strSql.Append("DDMID=@DDMID,"); strSql.Append("Prot=@Prot"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@Name", SqlDbType.VarChar, 150), new SqlParameter("@TType", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 50), new SqlParameter("@SupplierAddress", SqlDbType.VarChar, 150), new SqlParameter("@SupplierTelName", SqlDbType.VarChar, 50), new SqlParameter("@SupplierTel", SqlDbType.VarChar, 50), new SqlParameter("@CarID", SqlDbType.Int, 4), new SqlParameter("@CarSJ1", SqlDbType.VarChar, 50), new SqlParameter("@CarSJ2", SqlDbType.VarChar, 50), new SqlParameter("@CostType", SqlDbType.Int, 4), new SqlParameter("@BDImg", SqlDbType.VarChar, 250), new SqlParameter("@TState", SqlDbType.Int, 4), new SqlParameter("@IsDelete", SqlDbType.Int, 4), new SqlParameter("@Spare1", SqlDbType.VarChar, 250), new SqlParameter("@Spare2", SqlDbType.VarChar, 250), //new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@OCode", SqlDbType.VarChar, 50), new SqlParameter("@CSpare2", SqlDbType.VarChar, 50), new SqlParameter("@ComDate", SqlDbType.DateTime), new SqlParameter("@XSMID", SqlDbType.VarChar, 50), new SqlParameter("@DDMID", SqlDbType.VarChar, 50), new SqlParameter("@Prot", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.TType; parameters[2].Value = model.SupplierName; parameters[3].Value = model.SupplierAddress; parameters[4].Value = model.SupplierTelName; parameters[5].Value = model.SupplierTel; parameters[6].Value = model.CarID; parameters[7].Value = model.CarSJ1; parameters[8].Value = model.CarSJ2; parameters[9].Value = model.CostType; parameters[10].Value = model.BDImg; parameters[11].Value = model.TState; parameters[12].Value = model.IsDelete; parameters[13].Value = model.Spare1; parameters[14].Value = model.Spare2; //parameters[15].Value = model.CreateDate; parameters[15].Value = model.OCode; parameters[16].Value = model.CSpare2; parameters[17].Value = model.ComDate; parameters[18].Value = model.XSMID; parameters[19].Value = model.DDMID; parameters[20].Value = model.Prot; parameters[21].Value = model.ID; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }