/// <summary> /// 更新一条数据 /// </summary> public bool Update(YJUI.Model.renkuan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update renkuan set "); strSql.Append("BankInfo=@BankInfo,"); strSql.Append("HFee=@HFee,"); strSql.Append("Hmoney=@Hmoney,"); strSql.Append("Customer=@Customer"); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@BankInfo", SqlDbType.VarChar, 200), new SqlParameter("@HFee", SqlDbType.VarChar, 53), new SqlParameter("@Hmoney", SqlDbType.VarChar, 53), new SqlParameter("@Customer", SqlDbType.VarChar, 2000), new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = model.BankInfo; parameters[1].Value = model.HFee; parameters[2].Value = model.Hmoney; parameters[3].Value = model.Customer; parameters[4].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(YJUI.Model.renkuan model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into renkuan("); strSql.Append("WDate,BankInfo,HFee,Hmoney,Customer)"); strSql.Append(" values ("); strSql.Append("@WDate,@BankInfo,@HFee,@Hmoney,@Customer)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@WDate", SqlDbType.DateTime), new SqlParameter("@BankInfo", SqlDbType.VarChar, 200), new SqlParameter("@HFee", SqlDbType.VarChar, 53), new SqlParameter("@Hmoney", SqlDbType.VarChar, 53), new SqlParameter("@Customer", SqlDbType.VarChar, 2000) }; parameters[0].Value = model.WDate; parameters[1].Value = model.BankInfo; parameters[2].Value = model.HFee; parameters[3].Value = model.Hmoney; parameters[4].Value = model.Customer; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YJUI.Model.renkuan GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,WDate,BankInfo,TMode,HFee,Hmoney,CRemark,Customer,Employee,KRemark,State,QRemark,CustomerID,OrderID,SZJE,RKriqi,crdate,flag from renkuan "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; YJUI.Model.renkuan model = new YJUI.Model.renkuan(); 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 YJUI.Model.renkuan DataRowToModel(DataRow row) { YJUI.Model.renkuan model = new YJUI.Model.renkuan(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["WDate"] != null && row["WDate"].ToString() != "") { model.WDate = DateTime.Parse(row["WDate"].ToString()); } if (row["BankInfo"] != null) { model.BankInfo = row["BankInfo"].ToString(); } if (row["TMode"] != null) { model.TMode = row["TMode"].ToString(); } if (row["HFee"] != null) { model.HFee = row["HFee"].ToString(); } if (row["Hmoney"] != null) { model.Hmoney = row["Hmoney"].ToString(); } if (row["CRemark"] != null) { model.CRemark = row["CRemark"].ToString(); } if (row["Customer"] != null) { model.Customer = row["Customer"].ToString(); } if (row["Employee"] != null) { model.Employee = row["Employee"].ToString(); } if (row["KRemark"] != null) { model.KRemark = row["KRemark"].ToString(); } if (row["State"] != null) { model.State = row["State"].ToString(); } if (row["QRemark"] != null) { model.QRemark = row["QRemark"].ToString(); } if (row["CustomerID"] != null) { model.CustomerID = row["CustomerID"].ToString(); } if (row["OrderID"] != null) { model.OrderID = row["OrderID"].ToString(); } if (row["SZJE"] != null) { model.SZJE = row["SZJE"].ToString(); } if (row["RKriqi"] != null) { model.RKriqi = row["RKriqi"].ToString(); } if (row["crdate"] != null && row["crdate"].ToString() != "") { model.crdate = DateTime.Parse(row["crdate"].ToString()); } if (row["flag"] != null) { model.flag = row["flag"].ToString(); } } return(model); }