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);
}
}
