public int InsertOutput_storageRow(EntityOutput_storage outputStorage)
{
string SqlStr = "";
SqlStr = "INSERT INTO TC_OUTPUT_STORAGE "
+ "(OUTPUT_CODE ,input_code ,customer_code ,output_count ,output_check_persion"
+ ",output_oper ,output_quality_persion ,output_issued ,output_packing_in ,output_packing_mid"
+ ",output_packing_out ,output_remark ,output_instorage_date ,output_checktime ,output_type"
+ ",output_backreason ,operate_type)";
SqlStr += " VALUES ('" + outputStorage.Output_code.Trim() + "','" + outputStorage.Input_code.Trim() + "','" + outputStorage.Customer_code.Trim() + "',"
+ "" + outputStorage.Output_count + ",'" + outputStorage.Output_check_persion.Trim() + "','" + outputStorage.Output_oper.Trim() + "','" + outputStorage.Output_quality_persion.Trim() + "'"
+ ",'" + outputStorage.Output_issued.Trim() + "','" + outputStorage.Output_packing_in.Trim() + "','" + outputStorage.Output_packing_mid.Trim() + "','" + outputStorage.Output_packing_out.Trim() + "'"
+ ",'" + outputStorage.Output_remark.Trim() + "','" + outputStorage.Output_instorage_date + "','" + outputStorage.Output_checktime + "'," + outputStorage.Output_type.Trim() + ""
+ ",'" + outputStorage.Output_backreason.Trim() + "','" + outputStorage.Operate_type.Trim() + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
try
{
ExcuteSql(sqlCommand);
}
catch
{
return(Constants.SystemConfig.SERVER_ERROR);
}
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public int UpdateOutput_storage(EntityOutput_storage entity, SearchParameter sp)
{
//设置更新出库表SQL语句
string SqlStr = "";
SqlStr = "update tc_output_storage";
SqlStr += " set operate_type= '" + entity.Operate_type.Trim() + "'";
ArrayList arrayList = sp.Keys();
switch (sp.GetHashTable[arrayList[0]].GetType().Name)
{
case "String":
SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + " like '" + sp.GetValue(arrayList[0].ToString()) + "%'";
break;
case "Int32":
SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + "= " + sp.GetValue(arrayList[0].ToString()) + "";
break;
default:
SqlStr += " where " + arrayList[0].ToString().Replace(":", "") + " like '" + sp.GetValue(arrayList[0].ToString()) + "%'";
break;
}
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
//执行SQL语句
ExcuteSql(sqlCommand);
//返回操作成功结果
return(Constants.SystemConfig.SERVER_SUCCESS);
}
//***********************************************************************
/// <summary>
/// 确认按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：代国明 2010/07/22 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
if (txt_goods_name.Text.Trim() == "双击选择产品..." || txt_goods_name.Text.Trim() == string.Empty)
{
MessageBox.Show("产品名称不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_goods_name.Focus();
return;
}
if (txt_supplier_name.Text.Trim() == string.Empty)
{
MessageBox.Show("供货商不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_supplier_name.Focus();
return;
}
if (nud_output_count.Value == 0)
{
MessageBox.Show("退货数量不能为0！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
nud_output_count.Select();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dtp_output_checktime.Value.Date)
{
MessageBox.Show("请选择一个正确的验收日期！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtp_output_checktime.Select();
return;
}
//判断时间有效性
if (dtp_output_instorage_date.Value.Date > dtp_output_checktime.Value.Date)
{
MessageBox.Show("请选择一个正确的出库日期！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dtp_output_instorage_date.Select();
return;
}
if (txt_output_check_persion.Text.Trim() == "双击选择验收人..." || txt_output_check_persion.Text.Trim() == string.Empty)
{
MessageBox.Show("验收人不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_check_persion.Focus();
return;
}
if (txt_output_quality_persion.Text.Trim() == "双击选择质管员..." || txt_output_quality_persion.Text.Trim() == string.Empty)
{
MessageBox.Show("质管员不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_quality_persion.Focus();
return;
}
if (txt_output_oper.Text.Trim() == "双击选择业务员..." || txt_output_oper.Text.Trim() == string.Empty)
{
MessageBox.Show("业务员不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_oper.Focus();
return;
}
if (txt_output_issued.Text.Trim() == "双击选择经办人..." || txt_output_issued.Text.Trim() == string.Empty)
{
MessageBox.Show("经办人不能为空！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txt_output_issued.Focus();
return;
}
//if (cmb_output_packing_in.Text.Equals("请选择一种包装情况"))
//{
// MessageBox.Show("请选择一种包装情况", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// cmb_output_packing_in.Focus();
// return;
//}
//if (cmb_output_packing_mid.Text.Equals("请选择一种包装情况"))
//{
// MessageBox.Show("请选择一种包装情况", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// cmb_output_packing_mid.Focus();
// return;
//}
//if (cmb_output_packing_out.Text.Equals("请选择一种包装情况"))
//{
// MessageBox.Show("请选择一种包装情况", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
// cmb_output_packing_out.Focus();
// return;
//}
//添加后库存数目剪掉添加数目数据信息
UpdateStorageDetailsByAdd();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
//取得实体类
outputStorageEntity = new EntityOutput_storage();
//赋值实体类
outputStorageEntity.Output_checktime = Convert.ToDateTime(dtp_output_checktime.Value.ToString("yyyy-MM-dd"));
outputStorageEntity.Output_instorage_date = Convert.ToDateTime(dtp_output_instorage_date.Value.ToString("yyyy-MM-dd"));
outputStorageEntity.Output_count = Convert.ToInt32(nud_output_count.Value);
outputStorageEntity.Input_code = inputCode;
outputStorageEntity.Output_packing_in = cmb_output_packing_in.Text.ToString();
outputStorageEntity.Output_packing_mid = cmb_output_packing_mid.Text.ToString();
outputStorageEntity.Output_packing_out = cmb_output_packing_out.Text.ToString();
outputStorageEntity.Output_oper = txt_output_oper.Text.ToString();
outputStorageEntity.Output_quality_persion = txt_output_quality_persion.Text.ToString();
outputStorageEntity.Output_issued = txt_output_issued.Text.ToString();
outputStorageEntity.Output_check_persion = txt_output_check_persion.Text.ToString();
outputStorageEntity.Output_backreason = txt_output_reback_reason.Text.ToString();
outputStorageEntity.Output_remark = txt_output_remark.Text.ToString();
outputStorageEntity.Output_type = "1";
outputStorageEntity.Operate_type = "0";
//赋值实体类
inputStorageEntity = new EntityInput_storage();
inputStorageEntity.OPERATE_TYPE = '1';
inputStorageEntity.INPUT_CODE = inputCode;
//打开数据库连接
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey mpk = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
outputStorageEntity.Output_code = mpk.MakeCode("出库");
//取得操作类
GetData getData = new GetData(dataAccess.Connection);
//取得结果符
result = getData.InsertOutput_storageRow(outputStorageEntity);
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("数据已经保存失败！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
getData.UpdateOperate_typeByInput_codeRow(inputStorageEntity);
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
//关闭数据库连接
dataAccess.Close();
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BindingDgvOutputStorage();
}
}
//***********************************************************************
/// <summary>
/// 删除按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/26 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnDelete_Click(object sender, EventArgs e)
{
result = -1;
countNum = 0;
if (dgv.SelectedRows.Count > 1)
{
MessageBox.Show("只能选择一条要删除的记录！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (dgv.SelectedRows.Count < 1)
{
MessageBox.Show("请选择一条要删除的记录！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (MessageBox.Show("您确定要删除该数据吗？", Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
try
{
SearchParameter sp = new SearchParameter();
sp.SetValue(":Apparatus_quality_code", dgv.SelectedRows[0].Cells["Apparatus_quality_code"].Value.ToString());
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
result = getData.DeleteRow("tc_apparatus_quality", sp);
dataAccess.Commit();
}
catch (Exception ex)
{
dataAccess.Rollback();
MessageBox.Show(ex.Message);
throw ex;
}
finally
{
dataAccess.Close();
}
if (result == 0)
{
if (!updateMark())
{
try
{
dataAccess = new DataAccess();
dataAccess.Open();
GetData getData = new GetData(dataAccess.Connection);
//处理操作标示
EntityOutput_storage outputStorageEntity = new EntityOutput_storage();
outputStorageEntity.Operate_type = "0";
SearchParameter sp = new SearchParameter();
sp.SetValue(":output_code", txtApparatus_quality_output_code.Text);
result = getData.UpdateOutput_storage(outputStorageEntity, sp);
}
catch (Exception ex)
{
MessageBox.Show("请查看数据库是否正常！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
if (dataAccess.Connection != null)
{
dataAccess.Close();
}
}
}
MessageBox.Show("数据已经被成功删除！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据删除时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/7/26 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
//判断非法字符
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
//判断入库编号不为空
if (txtApparatus_quality_output_code.Text.Trim() == string.Empty || txtApparatus_quality_output_code.Text == "双击选择出库编号...")
{
MessageBox.Show("出库编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_quality_output_code.Focus();
return;
}
if (txtApparatus_quality_count.Text.Trim() == string.Empty)
{
MessageBox.Show("出问题产品数量不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_quality_count.Focus();
return;
}
if (Convert.ToInt32(txtApparatus_quality_count.Text.Trim()) == 0)
{
MessageBox.Show("出问题产品数量不能为0！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_quality_count.Focus();
return;
}
if (Convert.ToInt32(labelSellcount.Text) < Convert.ToInt32(txtApparatus_quality_count.Text.Trim()))
{
MessageBox.Show("输入的数量不能大于出售数量！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
labelSellcount.Focus();
return;
}
if (txtApparatus_speaker.Text.Trim() == string.Empty)
{
MessageBox.Show("报告人不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_speaker.Focus();
return;
}
if (txtApparatus_qualityt_issued.Text.Trim() == string.Empty || txtApparatus_qualityt_issued.Text == "双击选择经办人...")
{
MessageBox.Show("经办人不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtApparatus_qualityt_issued.Focus();
return;
}
//判断时间有效性
if (DateTime.Now.Date < dateApparatus_report_date.Value.Date)
{
MessageBox.Show("报告日期不能大于今天！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateApparatus_report_date.Focus();
return;
}
//判断时间有效性
if (dateApparatus_accident_management_date.Value.Date < dateApparatus_report_date.Value.Date)
{
MessageBox.Show("处理日期不能小于报告日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateApparatus_accident_management_date.Focus();
return;
}
//判断时间有效性
if (dateApparatus_report_date.Value.Date < outputInstorageDate)
{
MessageBox.Show("报告日期不能小于销售日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
EntityApparatus_quality entity = new EntityApparatus_quality();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entity.Apparatus_output_code = txtApparatus_quality_output_code.Text;
entity.Apparatus_accident_conditions = txtApparatus_accident_conditions.Text;
entity.Apparatus_accident_management = txtApparatus_accident_management.Text;
entity.Apparatus_accident_management_date = dateApparatus_accident_management_date.Value.Date;
entity.Apparatus_customer_feedback = txtApparatus_customer_feedback.Text;
entity.Apparatus_opinion_leader = txtApparatus_opinion_leader.Text;
entity.Apparatus_quality_count = Convert.ToInt32(txtApparatus_quality_count.Text.Trim());
entity.Apparatus_qualityt_issued = txtApparatus_qualityt_issued.Text;
entity.Apparatus_report_date = dateApparatus_report_date.Value.Date;
entity.Apparatus_speaker = txtApparatus_speaker.Text;
dataAccess = new DataAccess();
dataAccess.Open();
MakePrimaryKey primaryKey = new MakePrimaryKey(dataAccess.Connection, dataAccess.Transaction);
entity.Apparatus_quality_code = primaryKey.MakeCode("器械质量跟踪");
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertApparatus_quality(entity);
//处理操作标示
EntityOutput_storage outputStorageEntity = new EntityOutput_storage();
outputStorageEntity.Operate_type = "1";
SearchParameter sp = new SearchParameter();
sp.SetValue(":output_code", txtApparatus_quality_output_code.Text);
result = getData.UpdateOutput_storage(outputStorageEntity, sp);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entity.Apparatus_output_code = txtApparatus_quality_output_code.Text;
entity.Apparatus_accident_conditions = txtApparatus_accident_conditions.Text;
entity.Apparatus_accident_management = txtApparatus_accident_management.Text;
entity.Apparatus_accident_management_date = dateApparatus_accident_management_date.Value.Date;
entity.Apparatus_customer_feedback = txtApparatus_customer_feedback.Text;
entity.Apparatus_opinion_leader = txtApparatus_opinion_leader.Text;
entity.Apparatus_quality_count = Convert.ToInt32(txtApparatus_quality_count.Text.Trim());
entity.Apparatus_qualityt_issued = txtApparatus_qualityt_issued.Text;
entity.Apparatus_report_date = dateApparatus_report_date.Value.Date;
entity.Apparatus_speaker = txtApparatus_speaker.Text;
entity.Apparatus_quality_code = dgv.SelectedRows[0].Cells["Apparatus_quality_code"].Value.ToString();
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateApparatus_quality(entity);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
//重新加载画面
BandingDgv();
}
