private MaterialInModel _DataBind(int Code) { MaterialInModel model = new MaterialInModel(); StringBuilder builder = new StringBuilder(); builder.Append("select * from V_MaterialIn as MaterialIn "); builder.Append(" where MaterialInCode=@MaterialInCode"); this._DataProcess.CommandText = builder.ToString(); this._DataProcess.ProcessParametersAdd("@MaterialInCode", SqlDbType.Int, 4, Code); SqlDataReader sqlDataReader = null; try { sqlDataReader = this._DataProcess.GetSqlDataReader(); while (sqlDataReader.Read()) { this.Initialize(sqlDataReader, model); } } catch (SqlException exception) { throw exception; } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } return(model); }
private int _Insert(MaterialInModel mObj) { StringBuilder builder = new StringBuilder(); builder.Append("insert into MaterialIn("); builder.Append("MaterialInCode, MaterialInID,ProjectCode,GroupCode,InDate,InPerson,Status,InputPerson,InputDate,CheckPerson,CheckDate,ContractCode,Remark)"); builder.Append(" values ("); builder.Append("@MaterialInCode, @MaterialInID,@ProjectCode,@GroupCode,@InDate,@InPerson,@Status,@InputPerson,@InputDate,@CheckPerson,@CheckDate,@ContractCode,@Remark) "); this._DataProcess.CommandText = builder.ToString(); this._DataProcess.ProcessParametersAdd("@MaterialInCode", SqlDbType.Int, 4, mObj.MaterialInCode); this._DataProcess.ProcessParametersAdd("@MaterialInID", SqlDbType.VarChar, 50, mObj.MaterialInID); this._DataProcess.ProcessParametersAdd("@ProjectCode", SqlDbType.VarChar, 50, (mObj.ProjectCode == null) ? "" : mObj.ProjectCode); this._DataProcess.ProcessParametersAdd("@GroupCode", SqlDbType.VarChar, 50, mObj.GroupCode); this._DataProcess.ProcessParametersAdd("@InDate", SqlDbType.DateTime, 8, mObj.InDate); this._DataProcess.ProcessParametersAdd("@InPerson", SqlDbType.VarChar, 50, mObj.InPerson); this._DataProcess.ProcessParametersAdd("@Status", SqlDbType.Int, 4, mObj.Status); this._DataProcess.ProcessParametersAdd("@InputPerson", SqlDbType.VarChar, 50, mObj.InputPerson); this._DataProcess.ProcessParametersAdd("@InputDate", SqlDbType.DateTime, 8, mObj.InputDate); this._DataProcess.ProcessParametersAdd("@CheckPerson", SqlDbType.VarChar, 50, mObj.CheckPerson); this._DataProcess.ProcessParametersAdd("@CheckDate", SqlDbType.DateTime, 8, mObj.CheckDate); this._DataProcess.ProcessParametersAdd("@ContractCode", SqlDbType.VarChar, 50, mObj.ContractCode); this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 800, mObj.Remark); this._DataProcess.RunSql(); return(mObj.MaterialInCode); }
public int Update(MaterialInModel ObjModel) { int num = 0; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); try { num = new MaterialInBLL().Update(ObjModel, transaction); transaction.Commit(); return(num); } catch (SqlException exception) { transaction.Rollback(); connection.Close(); throw exception; } finally { connection.Close(); } } return(num); }
public int Update(MaterialInModel ObjModel, SqlTransaction Transaction) { MaterialInDAL ndal = new MaterialInDAL(Transaction); ObjModel.InputDate = DateTime.Now; return(ndal.Update(ObjModel)); }
private List <MaterialInModel> _Select(MaterialInQueryModel qmObj) { List <MaterialInModel> list = new List <MaterialInModel>(); StringBuilder builder = new StringBuilder(); builder.Append("select * from V_MaterialIn as MaterialIn "); builder.Append(qmObj.QueryConditionStr); if ((qmObj.SortColumns == null) || (qmObj.SortColumns.Length == 0)) { builder.Append(" ORDER BY MaterialInCode desc"); } else { builder.Append(" ORDER BY " + qmObj.SortColumns); } this._DataProcess.CommandText = builder.ToString(); this._DataProcess.SqlParameters = qmObj.Parameters; SqlDataReader sqlDataReader = null; int num = 0; try { sqlDataReader = this._DataProcess.GetSqlDataReader(); while (sqlDataReader.Read()) { if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1))) { MaterialInModel model = new MaterialInModel(); this.Initialize(sqlDataReader, model); list.Add(model); } num++; } } catch (SqlException exception) { throw exception; } finally { if (sqlDataReader != null) { sqlDataReader.Close(); } } return(list); }
public ActionResult MaterialInDataEditView(int MaterialInId) { GetMaterialInPurchaserList(); MaterialInModel model = new MaterialInModel(); MaterialIn newFitCat = db.MaterialIns.Where(a => a.MaterialInId.Equals(MaterialInId)).FirstOrDefault(); if (newFitCat != null) { model.MatInPurchaserId = newFitCat.MatInPurchaserId; model.PurchaseItem = newFitCat.PurchaseItem; model.Quantity = newFitCat.Quantity; model.Rate = newFitCat.Rate; model.Quality = newFitCat.Quality; model.Size = newFitCat.Size; model.Cartridge = newFitCat.Cartridge; } return(View("MaterialInDataSetup", model)); }
public ActionResult MaterialInDataSetup(MaterialInModel model) { System.Random random = new System.Random(); MaterialIn materialInData = db.MaterialIns.Where(a => a.MaterialInId.Equals(model.MaterialInId)).FirstOrDefault(); if (materialInData == null) { MaterialIn newMaterialInDataadd = new MaterialIn(); newMaterialInDataadd.MaterialInNo = "MatNo_" + random.Next(); newMaterialInDataadd.MatInPurchaserId = model.MatInPurchaserId; newMaterialInDataadd.PurchaseItem = model.PurchaseItem; newMaterialInDataadd.Quantity = model.Quantity; newMaterialInDataadd.Rate = model.Rate; newMaterialInDataadd.IsDebit = true; newMaterialInDataadd.IsCredit = false; newMaterialInDataadd.Quality = model.Quality; newMaterialInDataadd.Size = model.Size; newMaterialInDataadd.Cartridge = model.Cartridge; newMaterialInDataadd.CreateDate = DateTime.Now; newMaterialInDataadd.IsActive = true; db.MaterialIns.Add(newMaterialInDataadd); db.SaveChanges(); ModelState.Clear(); model = null; this.AddNotification("Thats great! Successfully Saved.", NotificationType.SUCCESS); } else { materialInData.MatInPurchaserId = model.MatInPurchaserId; materialInData.PurchaseItem = model.PurchaseItem; materialInData.Quantity = model.Quantity; materialInData.Rate = model.Rate; materialInData.Quality = model.Quality; materialInData.Size = model.Size; materialInData.Cartridge = model.Cartridge; db.SaveChanges(); model = null; this.AddNotification("Thats great! Successfully Edited.", NotificationType.SUCCESS); } return(RedirectToAction("MaterialInDataList")); }
public MaterialInModel GetMaterialIn(int Code) { MaterialInModel model = new MaterialInModel(); SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()); try { model = new MaterialInBLL().GetModel(Code, connection); connection.Close(); } catch (SqlException exception) { throw exception; } finally { if (connection != null) { connection.Dispose(); } } return(model); }
public int Update(MaterialInModel mObj) { return(this._Update(mObj)); }
public int Insert(MaterialInModel mObj) { return(this._Insert(mObj)); }
private void Initialize(SqlDataReader reader, MaterialInModel obj) { if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")) != DBNull.Value) { obj.MaterialInCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")) != DBNull.Value) { obj.MaterialInID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")) != DBNull.Value) { obj.ProjectCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")) != DBNull.Value) { obj.GroupCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate")) != DBNull.Value) { obj.InDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPerson")) != DBNull.Value) { obj.InPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPerson")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Status")) != DBNull.Value) { obj.Status = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Status")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputPerson")) != DBNull.Value) { obj.InputPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputPerson")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputDate")) != DBNull.Value) { obj.InputDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckPerson")) != DBNull.Value) { obj.CheckPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckPerson")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckDate")) != DBNull.Value) { obj.CheckDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckDate")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode")) != DBNull.Value) { obj.ContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark")) != DBNull.Value) { obj.Remark = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractID")) != DBNull.Value) { obj.ContractID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractID")); } if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractName")) != DBNull.Value) { obj.ContractName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractName")); } }
public int Delete(MaterialInModel mObj) { return(this._Delete(mObj.MaterialInCode)); }
private int _Update(MaterialInModel mObj) { StringBuilder builder = new StringBuilder(); builder.Append("update MaterialIn set "); if (mObj.MaterialInID != null) { builder.Append("MaterialInID=@MaterialInID,"); this._DataProcess.ProcessParametersAdd("@MaterialInID", SqlDbType.VarChar, 50, mObj.MaterialInID); } if (mObj.ProjectCode != null) { builder.Append("ProjectCode=@ProjectCode,"); this._DataProcess.ProcessParametersAdd("@ProjectCode", SqlDbType.VarChar, 50, mObj.ProjectCode); } if (mObj.GroupCode != null) { builder.Append("GroupCode=@GroupCode,"); this._DataProcess.ProcessParametersAdd("@GroupCode", SqlDbType.VarChar, 50, mObj.GroupCode); } if (mObj.InDate != DateTime.MinValue) { builder.Append("InDate=@InDate,"); this._DataProcess.ProcessParametersAdd("@InDate", SqlDbType.DateTime, 8, mObj.InDate); } if (mObj.InPerson != null) { builder.Append("InPerson=@InPerson,"); this._DataProcess.ProcessParametersAdd("@InPerson", SqlDbType.VarChar, 50, mObj.InPerson); } if (mObj.Status != 0) { builder.Append("Status=@Status,"); this._DataProcess.ProcessParametersAdd("@Status", SqlDbType.Int, 4, mObj.Status); } if (mObj.InputPerson != null) { builder.Append("InputPerson=@InputPerson,"); this._DataProcess.ProcessParametersAdd("@InputPerson", SqlDbType.VarChar, 50, mObj.InputPerson); } if (mObj.InputDate != DateTime.MinValue) { builder.Append("InputDate=@InputDate,"); this._DataProcess.ProcessParametersAdd("@InputDate", SqlDbType.DateTime, 8, mObj.InputDate); } if (mObj.CheckPerson != null) { builder.Append("CheckPerson=@CheckPerson,"); this._DataProcess.ProcessParametersAdd("@CheckPerson", SqlDbType.VarChar, 50, mObj.CheckPerson); } if (mObj.CheckDate != DateTime.MinValue) { builder.Append("CheckDate=@CheckDate,"); this._DataProcess.ProcessParametersAdd("@CheckDate", SqlDbType.DateTime, 8, mObj.CheckDate); } if (mObj.ContractCode != null) { builder.Append("ContractCode=@ContractCode,"); this._DataProcess.ProcessParametersAdd("@ContractCode", SqlDbType.VarChar, 50, mObj.ContractCode); } if (mObj.Remark != null) { builder.Append("Remark=@Remark,"); this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 800, mObj.Remark); } builder.Remove(builder.Length - 1, 1); builder.Append(" where MaterialInCode=@MaterialInCode"); this._DataProcess.ProcessParametersAdd("@MaterialInCode", SqlDbType.Int, 4, mObj.MaterialInCode); this._DataProcess.CommandText = builder.ToString(); return(this._DataProcess.RunSql()); }
public int Delete(MaterialInModel ObjModel, SqlTransaction Transaction) { return(this.Delete(ObjModel.MaterialInCode, Transaction)); }