/// <summary> /// 增加一条数据 /// </summary> public static int Add(yny_005.Model.Account model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Account("); strSql.Append("CID,CName,AType,SupplierID,SupplierName,TotalMoney,ReMoney,CreateDate,AStutas,Spare,Spare2,Spare3,comDate,OrderCount,OrderPrice)"); strSql.Append(" values ("); strSql.Append("@CID,@CName,@AType,@SupplierID,@SupplierName,@TotalMoney,@ReMoney,@CreateDate,@AStutas,@Spare,@Spare2,@Spare3,@comDate,@OrderCount,@OrderPrice)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CID", SqlDbType.Int, 4), new SqlParameter("@CName", SqlDbType.VarChar, 50), new SqlParameter("@AType", SqlDbType.Int, 4), new SqlParameter("@SupplierID", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 250), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@ReMoney", SqlDbType.Decimal, 9), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@AStutas", SqlDbType.Int, 4), new SqlParameter("@Spare", SqlDbType.VarChar, 50), new SqlParameter("@Spare2", SqlDbType.VarChar, 50), new SqlParameter("@Spare3", SqlDbType.Int, 4), new SqlParameter("@comDate", SqlDbType.DateTime), new SqlParameter("@OrderCount",SqlDbType.Decimal,9), new SqlParameter("@OrderPrice", SqlDbType.Decimal, 9) }; parameters[0].Value = model.CID; parameters[1].Value = model.CName; parameters[2].Value = model.AType; parameters[3].Value = model.SupplierID; parameters[4].Value = model.SupplierName; parameters[5].Value = model.TotalMoney; parameters[6].Value = model.ReMoney; parameters[7].Value = model.CreateDate; parameters[8].Value = model.AStutas; parameters[9].Value = model.Spare; parameters[10].Value = model.Spare2; parameters[11].Value = model.Spare3; parameters[12].Value = model.comDate; parameters[13].Value = model.OrderCount; parameters[14].Value = model.OrderPrice; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Add(yny_005.Model.Account model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Account("); strSql.Append("CID,CName,AType,SupplierID,SupplierName,TotalMoney,ReMoney,CreateDate,AStutas,Spare,Spare2,Spare3,comDate,OrderCount,OrderPrice)"); strSql.Append(" values ("); strSql.Append("@CID,@CName,@AType,@SupplierID,@SupplierName,@TotalMoney,@ReMoney,@CreateDate,@AStutas,@Spare,@Spare2,@Spare3,@comDate,@OrderCount,@OrderPrice)"); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@CID", SqlDbType.Int, 4), new SqlParameter("@CName", SqlDbType.VarChar, 50), new SqlParameter("@AType", SqlDbType.Int, 4), new SqlParameter("@SupplierID", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 250), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@ReMoney", SqlDbType.Decimal, 9), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@AStutas", SqlDbType.Int, 4), new SqlParameter("@Spare", SqlDbType.VarChar, 50), new SqlParameter("@Spare2", SqlDbType.VarChar, 50), new SqlParameter("@Spare3", SqlDbType.Int, 4), new SqlParameter("@comDate", SqlDbType.DateTime), new SqlParameter("@OrderCount",SqlDbType.Decimal,9), new SqlParameter("@OrderPrice", SqlDbType.Decimal, 9) }; parameters[0].Value = model.CID; parameters[1].Value = model.CName; parameters[2].Value = model.AType; parameters[3].Value = model.SupplierID; parameters[4].Value = model.SupplierName; parameters[5].Value = model.TotalMoney; parameters[6].Value = model.ReMoney; parameters[7].Value = model.CreateDate; parameters[8].Value = model.AStutas; parameters[9].Value = model.Spare; parameters[10].Value = model.Spare2; parameters[11].Value = model.Spare3; parameters[12].Value = model.comDate; parameters[13].Value = model.OrderCount; parameters[14].Value = model.OrderPrice; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 得到一个对象实体 /// </summary> public static yny_005.Model.Account GetModelName(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,CID,CName,AType,SupplierID,SupplierName,TotalMoney,ReMoney,CreateDate,AStutas,Spare,Spare2,Spare3,comDate,OrderCount,OrderPrice from Account "); strSql.Append(" where CName=@CName"); SqlParameter[] parameters = { new SqlParameter("@CName", SqlDbType.VarChar, 50) }; parameters[0].Value = ID; yny_005.Model.Account model = new yny_005.Model.Account(); 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 yny_005.Model.Account DataRowToModel(DataRow row) { yny_005.Model.Account model = new yny_005.Model.Account(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["CID"] != null && row["CID"].ToString() != "") { model.CID = int.Parse(row["CID"].ToString()); } if (row["CName"] != null) { model.CName = row["CName"].ToString(); } if (row["AType"] != null && row["AType"].ToString() != "") { model.AType = int.Parse(row["AType"].ToString()); } if (row["SupplierID"] != null && row["SupplierID"].ToString() != "") { model.SupplierID = int.Parse(row["SupplierID"].ToString()); } if (row["SupplierName"] != null) { model.SupplierName = row["SupplierName"].ToString(); } if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "") { model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString()); } if (row["ReMoney"] != null && row["ReMoney"].ToString() != "") { model.ReMoney = decimal.Parse(row["ReMoney"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["AStutas"] != null && row["AStutas"].ToString() != "") { model.AStutas = int.Parse(row["AStutas"].ToString()); } if (row["Spare"] != null) { model.Spare = row["Spare"].ToString(); } if (row["Spare2"] != null) { model.Spare2 = row["Spare2"].ToString(); } if (row["Spare3"] != null && row["Spare3"].ToString() != "") { model.Spare3 = int.Parse(row["Spare3"].ToString()); } if (row["comDate"] != null && row["comDate"].ToString() != "") { model.comDate = DateTime.Parse(row["comDate"].ToString()); } if (row["OrderCount"] != null && row["OrderCount"].ToString() != "") { model.OrderCount = decimal.Parse(row["OrderCount"].ToString()); } if (row["OrderPrice"] != null && row["OrderPrice"].ToString() != "") { model.OrderPrice = decimal.Parse(row["OrderPrice"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public static Hashtable Update(yny_005.Model.Account model, Hashtable MyHs) { string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("update Account set "); strSql.Append("CID=@CID,"); strSql.Append("CName=@CName,"); strSql.Append("AType=@AType,"); strSql.Append("SupplierID=@SupplierID,"); strSql.Append("SupplierName=@SupplierName,"); strSql.Append("TotalMoney=@TotalMoney,"); strSql.Append("ReMoney=@ReMoney,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("AStutas=@AStutas,"); strSql.Append("Spare=@Spare,"); strSql.Append("Spare2=@Spare2,"); strSql.Append("Spare3=@Spare3,"); strSql.Append("comDate=@comDate,"); strSql.Append("OrderCount=@OrderCount,"); strSql.Append("OrderPrice=@OrderPrice"); strSql.Append(" where ID=@ID"); strSql.AppendFormat(" ;select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@CID", SqlDbType.Int, 4), new SqlParameter("@CName", SqlDbType.VarChar, 50), new SqlParameter("@AType", SqlDbType.Int, 4), new SqlParameter("@SupplierID", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 250), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@ReMoney", SqlDbType.Decimal, 9), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@AStutas", SqlDbType.Int, 4), new SqlParameter("@Spare", SqlDbType.VarChar, 50), new SqlParameter("@Spare2", SqlDbType.VarChar, 50), new SqlParameter("@Spare3", SqlDbType.Int, 4), new SqlParameter("@comDate", SqlDbType.DateTime), new SqlParameter("@OrderCount", SqlDbType.Decimal, 9), new SqlParameter("@OrderPrice", SqlDbType.Decimal, 9), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.CID; parameters[1].Value = model.CName; parameters[2].Value = model.AType; parameters[3].Value = model.SupplierID; parameters[4].Value = model.SupplierName; parameters[5].Value = model.TotalMoney; parameters[6].Value = model.ReMoney; parameters[7].Value = model.CreateDate; parameters[8].Value = model.AStutas; parameters[9].Value = model.Spare; parameters[10].Value = model.Spare2; parameters[11].Value = model.Spare3; parameters[12].Value = model.comDate; parameters[13].Value = model.OrderCount; parameters[14].Value = model.OrderPrice; parameters[15].Value = model.ID; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 更新一条数据 /// </summary> public static bool Update(yny_005.Model.Account model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Account set "); strSql.Append("CID=@CID,"); strSql.Append("CName=@CName,"); strSql.Append("AType=@AType,"); strSql.Append("SupplierID=@SupplierID,"); strSql.Append("SupplierName=@SupplierName,"); strSql.Append("TotalMoney=@TotalMoney,"); strSql.Append("ReMoney=@ReMoney,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("AStutas=@AStutas,"); strSql.Append("Spare=@Spare,"); strSql.Append("Spare2=@Spare2,"); strSql.Append("Spare3=@Spare3,"); strSql.Append("comDate=@comDate,"); strSql.Append("OrderCount=@OrderCount,"); strSql.Append("OrderPrice=@OrderPrice"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@CID", SqlDbType.Int, 4), new SqlParameter("@CName", SqlDbType.VarChar, 50), new SqlParameter("@AType", SqlDbType.Int, 4), new SqlParameter("@SupplierID", SqlDbType.Int, 4), new SqlParameter("@SupplierName", SqlDbType.VarChar, 250), new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9), new SqlParameter("@ReMoney", SqlDbType.Decimal, 9), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@AStutas", SqlDbType.Int, 4), new SqlParameter("@Spare", SqlDbType.VarChar, 50), new SqlParameter("@Spare2", SqlDbType.VarChar, 50), new SqlParameter("@Spare3", SqlDbType.Int, 4), new SqlParameter("@comDate", SqlDbType.DateTime), new SqlParameter("@OrderCount", SqlDbType.Decimal, 9), new SqlParameter("@OrderPrice", SqlDbType.Decimal, 9), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.CID; parameters[1].Value = model.CName; parameters[2].Value = model.AType; parameters[3].Value = model.SupplierID; parameters[4].Value = model.SupplierName; parameters[5].Value = model.TotalMoney; parameters[6].Value = model.ReMoney; parameters[7].Value = model.CreateDate; parameters[8].Value = model.AStutas; parameters[9].Value = model.Spare; parameters[10].Value = model.Spare2; parameters[11].Value = model.Spare3; parameters[12].Value = model.comDate; parameters[13].Value = model.OrderCount; parameters[14].Value = model.OrderPrice; parameters[15].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }