private void LoadBatchList() { DataTable dtBatch; Model.Batch batch = new Model.Batch() { ClassId = Convert.ToInt32(ddlClass.SelectedValue) }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Batch = scope.Resolve <IBatch>(); dtBatch = Batch.Batch_GetAll(batch); } if (dtBatch != null) { ddlBatch.DataSource = dtBatch; ddlBatch.DataTextField = "BatchName"; ddlBatch.DataValueField = "BatchId"; ddlBatch.DataBind(); ddlBatchEvent.DataSource = dtBatch; ddlBatchEvent.DataTextField = "BatchName"; ddlBatchEvent.DataValueField = "BatchId"; ddlBatchEvent.DataBind(); } ddlBatchEvent.InsertSelect(); ddlBatch.InsertSelect(); }
private void Batch_GetById() { DataTable dtBatch; Model.Batch batch = new Model.Batch() { BatchId = this.BatchId }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Batch = scope.Resolve <IBatch>(); dtBatch = Batch.Batch_GetAll(batch); } if (dtBatch != null && dtBatch.Rows.Count > 0) { ddlBranch.SelectedValue = dtBatch.Rows[0]["BranchId"].ToString(); ddlClass.SelectedValue = dtBatch.Rows[0]["ClassId"].ToString(); ddlHost.SelectedValue = dtBatch.Rows[0]["HostId"].ToString(); ddlYear.SelectedValue = dtBatch.Rows[0]["Year"].ToString(); txtDescription.Text = dtBatch.Rows[0]["Description"].ToString(); txtBatchName.Text = dtBatch.Rows[0]["BranchName"].ToString(); txtEndDate.Text = Convert.ToDateTime(dtBatch.Rows[0]["EndDate"].ToString()).ToString("dd MMM yyyy"); txtStartDate.Text = Convert.ToDateTime(dtBatch.Rows[0]["StartDate"].ToString()).ToString("dd MMM yyyy"); chkCompleted.Checked = Convert.ToBoolean(dtBatch.Rows[0]["IsCompleted"].ToString()); } }
/// <summary> /// 根据编号,获取批次对象。 /// </summary> /// <param name="nnum">批次编号</param> public Model.Batch getBatchByNum(string nnum) { Model.Batch batch = null; string sqltext = "select * from batch where batchNum=@batchNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@batchNum", nnum); para.Add(sqlpara1); SqlDataReader sdr = DBTools.exereaderSQL(sqltext, para); while (sdr.Read()) { batch = new Model.Batch(); batch.BatchNum = sdr["batchNum"].ToString(); batch.OutorinType = sdr["outorinType"].ToString(); batch.ProorrecNum = sdr["proorrecNum"].ToString(); batch.Condition = sdr["condition"].ToString(); if (batch.OutorinType == "入库") { batch.Provider = new DAL.ProviderDAO().getProviderByNum(batch.ProorrecNum); } else if (batch.OutorinType == "出库") { batch.Receiver = new DAL.ReceiverDAO().getReceiverByNum(batch.ProorrecNum); } } sdr.Close(); return(batch); }
/// <summary> /// 获取所有的批次对象。 /// </summary> public List <Model.Batch> getAllBatches() { List <Model.Batch> batch = new List <Model.Batch>(); string sqltext = "select * from batch"; SqlDataReader sdr = DBTools.exereaderSQL(sqltext, new List <SqlParameter> ()); while (sdr.Read()) { Model.Batch b = new Model.Batch(); b.BatchNum = sdr["batchNum"].ToString(); b.OutorinType = sdr["outorinType"].ToString(); b.ProorrecNum = sdr["proorrecNum"].ToString(); if (b.OutorinType == "入库") { b.Provider = new DAL.ProviderDAO().getProviderByNum(b.ProorrecNum); } else if (b.OutorinType == "出库") { b.Receiver = new DAL.ReceiverDAO().getReceiverByNum(b.ProorrecNum); } b.Condition = sdr["condition"].ToString(); batch.Add(b); } sdr.Close(); DBTools.DBClose(); return(batch); }
private void LoadBatchList() { DataTable dtBatch; Model.Batch batch = new Model.Batch() { }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Batch = scope.Resolve <IBatch>(); dtBatch = Batch.Batch_GetAll(batch); } if (dtBatch != null) { dgvBatch.DataSource = dtBatch; dgvBatch.DataBind(); } }
private DataTable LoadBatchData() { DataTable dtBatch; Model.Batch batch = new Model.Batch() { BatchName = txtBatchName.Text.Trim(), BranchId = Convert.ToInt32(ddlBranch.SelectedValue), ClassId = Convert.ToInt32(ddlClass.SelectedValue), HostId = Convert.ToInt32(ddlHost.SelectedValue), Year = Convert.ToInt32(ddlYear.SelectedValue) }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Batch = scope.Resolve <IBatch>(); dtBatch = Batch.Batch_GetAll(batch); } return(dtBatch); }
public int Batch_Save(Model.Batch batch) { int BatchId = 0; using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = "usp_Batch_Save"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BatchId", batch.BatchId).Direction = ParameterDirection.InputOutput;; if (batch.ClassId == 0) { cmd.Parameters.AddWithValue("@ClassId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ClassId", batch.ClassId); } cmd.Parameters.AddWithValue("@BatchName", batch.BatchName); cmd.Parameters.AddWithValue("@Description", batch.Description); cmd.Parameters.AddWithValue("@BranchId", batch.BranchId); cmd.Parameters.AddWithValue("@StartDate", batch.StartDate); cmd.Parameters.AddWithValue("@EndDate", batch.EndDate); cmd.Parameters.AddWithValue("@Year", batch.Year); cmd.Parameters.AddWithValue("@HostId", batch.HostId); cmd.Parameters.AddWithValue("@IsComplete", batch.IsCompleted); cmd.Parameters.AddWithValue("@CreatedBy", batch.CreatedBy); if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); BatchId = Convert.ToInt32(cmd.Parameters["@BatchId"].Value); con.Close(); } } return(BatchId); }
protected void btnSave_Click(object sender, EventArgs e) { int response = 0; Model.Batch batch = new Model.Batch() { BatchId = this.BatchId, BatchName = txtBatchName.Text.Trim(), Description = txtDescription.Text.Trim(), ClassId = Convert.ToInt32(ddlClass.SelectedValue), BranchId = Convert.ToInt32(ddlBranch.SelectedValue), CreatedBy = 1, EndDate = Convert.ToDateTime(txtEndDate.Text), HostId = Convert.ToInt32(ddlHost.SelectedValue), IsCompleted = chkCompleted.Checked, StartDate = Convert.ToDateTime(txtStartDate.Text), Year = Convert.ToInt32(ddlYear.SelectedValue) }; using (var scope = Startup.Container.BeginLifetimeScope()) { var Batch = scope.Resolve <IBatch>(); response = Batch.Batch_Save(batch); } if (response > 0) { ClearControls(); LoadBatchList(); Message.IsSuccess = true; Message.Text = "Saved Successfully"; } else { Message.IsSuccess = false; Message.Text = "Host Name Exists"; } }
/// <summary> /// 添加一个批次。 /// </summary> /// <param name="bat">批次对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool addBatch(Model.Batch bat) { string sqltext = "insert batch(batchNum,outorinType,proorrecNum,condition) values(@batchNum,@outorinType,@proorrecNum,@condition)"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@batchNum", bat.BatchNum); SqlParameter sqlpara2 = new SqlParameter("@outorinType", bat.OutorinType); SqlParameter sqlpara3 = new SqlParameter("@proorrecNum", bat.ProorrecNum); SqlParameter sqlpara4 = new SqlParameter("@condition", bat.Condition); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个批次信息。 /// </summary> /// <param name="bat">批次对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool updateBatch(Model.Batch bat) { string sqltext = "update batch set outorinType=@outorinType,proorrecNum=@proorrecNum,condition=@condition where batchNum=@batchNum"; List <SqlParameter> para = new List <SqlParameter>(); SqlParameter sqlpara1 = new SqlParameter("@outorinType", bat.OutorinType); SqlParameter sqlpara2 = new SqlParameter("@proorrecNum", bat.ProorrecNum); SqlParameter sqlpara3 = new SqlParameter("@condition", bat.Condition); SqlParameter sqlpara4 = new SqlParameter("@batchNum", bat.BatchNum); para.Add(sqlpara1); para.Add(sqlpara2); para.Add(sqlpara3); para.Add(sqlpara4); int i = DBTools.exenonquerySQL(sqltext, para); if (i == 1) { return(true); } else { return(false); } }
/// <summary> /// 更新某个批次,批次编号不变。 /// </summary> /// <param name="bat">批次对象</param> /// <returns>通过布尔值判断操作是否成功。</returns> public bool updateBatch(Model.Batch bat) { throw new System.NotImplementedException(); }
public DataTable Batch_GetAll(Model.Batch batch) { return(_Batch.Batch_GetAll(batch)); }
public int Batch_Save(Model.Batch batch) { return(_Batch.Batch_Save(batch)); }
public DataTable Batch_GetAll(Model.Batch batch) { using (DataTable dt = new DataTable()) { using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString())) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_Batch_GetAll"; if (batch.BatchId == 0) { cmd.Parameters.AddWithValue("@BatchId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@BatchId", batch.BatchId); } if (string.IsNullOrEmpty(batch.BatchName)) { cmd.Parameters.AddWithValue("@BatchName", DBNull.Value); } else { cmd.Parameters.AddWithValue("@BatchName", batch.BatchName); } if (batch.BranchId == 0) { cmd.Parameters.AddWithValue("@BranchId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@BranchId", batch.BranchId); } if (batch.Year == 0) { cmd.Parameters.AddWithValue("@Year", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Year", batch.Year); } if (batch.HostId == 0) { cmd.Parameters.AddWithValue("@HostId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@HostId", batch.HostId); } if (batch.ClassId == 0) { cmd.Parameters.AddWithValue("@ClassId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ClassId", batch.ClassId); } if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }