/// <summary>对象实体绑定数据 /// /// </summary> public Nikita.Assist.CodeMaker.Model.OrderDetail ReaderBind(IDataReader dataReader) { Nikita.Assist.CodeMaker.Model.OrderDetail model = new Nikita.Assist.CodeMaker.Model.OrderDetail(); object ojb; ojb = dataReader["DetailId"]; if (ojb != null && ojb != DBNull.Value) { model.DetailId = int.Parse(ojb.ToString()); } ojb = dataReader["OrderId"]; if (ojb != null && ojb != DBNull.Value) { model.OrderId = int.Parse(ojb.ToString()); } model.Customer = dataReader["Customer"].ToString(); model.ProductName = dataReader["ProductName"].ToString(); ojb = dataReader["Amount"]; if (ojb != null && ojb != DBNull.Value) { model.Amount = int.Parse(ojb.ToString()); } ojb = dataReader["SumMoney"]; if (ojb != null && ojb != DBNull.Value) { model.SumMoney = double.Parse(ojb.ToString()); } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = bool.Parse(ojb.ToString()); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Assist.CodeMaker.Model.OrderDetail GetModel(int DetailId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from OrderDetail "); strSql.Append(" where DetailId=@DetailId "); DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); h.AddParameter("@DetailId", DetailId); Nikita.Assist.CodeMaker.Model.OrderDetail model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Assist.CodeMaker.Model.OrderDetail GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from OrderDetail "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); Nikita.Assist.CodeMaker.Model.OrderDetail model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>更新一条数据 /// /// </summary> public bool Update(Nikita.Assist.CodeMaker.Model.OrderDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OrderDetail set "); strSql.Append("OrderId=@OrderId, Customer=@Customer, ProductName=@ProductName, Amount=@Amount, SumMoney=@SumMoney, Status=@Status "); strSql.Append(" where DetailId=@DetailId "); DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); if (model.DetailId == null) { h.AddParameter("@DetailId", DBNull.Value); } else { h.AddParameter("@DetailId", model.DetailId); } if (model.OrderId == null) { h.AddParameter("@OrderId", DBNull.Value); } else { h.AddParameter("@OrderId", model.OrderId); } if (model.Customer == null) { h.AddParameter("@Customer", DBNull.Value); } else { h.AddParameter("@Customer", model.Customer); } if (model.ProductName == null) { h.AddParameter("@ProductName", DBNull.Value); } else { h.AddParameter("@ProductName", model.ProductName); } if (model.Amount == null) { h.AddParameter("@Amount", DBNull.Value); } else { h.AddParameter("@Amount", model.Amount); } if (model.SumMoney == null) { h.AddParameter("@SumMoney", DBNull.Value); } else { h.AddParameter("@SumMoney", model.SumMoney); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } return(h.ExecuteNonQuery()); }
/// <summary>增加一条数据 /// /// </summary> public int Add(Nikita.Assist.CodeMaker.Model.OrderDetail model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OrderDetail("); strSql.Append("OrderId, Customer, ProductName, Amount, SumMoney, Status )"); strSql.Append(" values ("); strSql.Append("@OrderId, @Customer, @ProductName, @Amount, @SumMoney, @Status )"); strSql.Append(";select @@IDENTITY"); DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo(); h.CreateCommand(strSql.ToString()); if (model.OrderId == null) { h.AddParameter("@OrderId", DBNull.Value); } else { h.AddParameter("@OrderId", model.OrderId); } if (model.Customer == null) { h.AddParameter("@Customer", DBNull.Value); } else { h.AddParameter("@Customer", model.Customer); } if (model.ProductName == null) { h.AddParameter("@ProductName", DBNull.Value); } else { h.AddParameter("@ProductName", model.ProductName); } if (model.Amount == null) { h.AddParameter("@Amount", DBNull.Value); } else { h.AddParameter("@Amount", model.Amount); } if (model.SumMoney == null) { h.AddParameter("@SumMoney", DBNull.Value); } else { h.AddParameter("@SumMoney", model.SumMoney); } if (model.Status == null) { h.AddParameter("@Status", DBNull.Value); } else { h.AddParameter("@Status", model.Status); } int intResult; string obj = h.ExecuteScalar(); if (!int.TryParse(obj, out intResult)) { return(0); } return(intResult); }