private void button1_Click(object sender, EventArgs e)
{
if (this.textBox2.Text == null || this.textBox2.Text.Trim() == "")
{
MessageBox.Show("必填描述不能為空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.textBox2.Focus();
return;
}
if (this.textBox1.Text != null && this.textBox1.Text != "")
{
MessageBox.Show("该模板必填规则已经保存！請勿重複保存", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
MandatoryInfo manInfo = new MandatoryInfo();
manInfo.Mandesc = this.textBox2.Text == null ? "" : this.textBox2.Text.Trim();
MandatoryInfo reMandatory = printQ.saveManField(manInfo);
if (reMandatory != null)
{
this.textBox1.Text = reMandatory.Manno;
this.textBox3.Text = reMandatory.Opuser;
this.textBox4.Text = reMandatory.Createtime;
MessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("保存失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
if (this.comboBox2.SelectedValue == null || this.comboBox2.SelectedValue.ToString().Trim() == "")
{
MessageBox.Show("字段規則不能為空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.clearAll();
this.comboBox2.Focus();
return;
}
MandatoryInfo mandatoryInfo = mandatoryFieldService.queryMandatoryInfoByNo(this.comboBox2.SelectedValue.ToString().Trim());
if (mandatoryInfo != null)
{
//查詢用戶實體內容
this.textBox3.Text = mandatoryInfo.Manno;
this.textBox4.Text = mandatoryInfo.Opuser;
this.textBox5.Text = mandatoryInfo.Createtime;
displayList(mandatoryInfo.Manno);
}
else
{
this.clearAll();
this.comboBox2.Focus();
return;
}
}
/// <summary>
/// 根據manNo模糊查詢
/// </summary>
/// <param name="manNo"></param>
/// <returns></returns>
public List <MandatoryInfo> queryMandatoryInfoList(string manNo)
{
List <MandatoryInfo> mandatoryInfoList = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,man_no,man_desc,op_user,create_time FROM t_mandatory_info WHERE man_no LIKE @manNo AND del_flag is null order by create_time");
MySqlParameter[] parameters =
{
new MySqlParameter("@manNo", MySqlDbType.VarChar, 900),
};
parameters[0].Value = "%" + manNo + "%";
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
mandatoryInfoList = new List <MandatoryInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
MandatoryInfo mandatoryInfo = new MandatoryInfo();
mandatoryInfo.Uuid = dr["uuid"].ToString();
mandatoryInfo.Manno = dr["man_no"].ToString();
mandatoryInfo.Mandesc = dr["man_desc"].ToString();
mandatoryInfo.Opuser = dr["op_user"].ToString();
mandatoryInfo.Createtime = dr["create_time"].ToString();
mandatoryInfoList.Add(mandatoryInfo);
}
}
return(mandatoryInfoList);
}
/// <summary>
/// 保存必填字段信息
/// </summary>
/// <param name="mandatoryInfo"></param>
/// <returns></returns>
public bool saveMandatoryInfo(MandatoryInfo mandatoryInfo)
{
bool saveMark = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into t_mandatory_info (uuid,man_desc,op_user,create_time)");
strSql.Append("values(@uuid,@manDesc,@opUser,@createTime)");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
new MySqlParameter("@manDesc", MySqlDbType.VarChar, 900),
new MySqlParameter("@opUser", MySqlDbType.VarChar, 900),
new MySqlParameter("@createTime", MySqlDbType.VarChar, 900)
};
parameters[0].Value = mandatoryInfo.Uuid;
parameters[1].Value = mandatoryInfo.Mandesc;
parameters[2].Value = mandatoryInfo.Opuser;
parameters[3].Value = mandatoryInfo.Createtime;
int rows = SQLHelper.ExecuteNonQuery(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (rows > 0)
{
saveMark = true;
}
else
{
saveMark = false;
}
return(saveMark);
}
/// <summary>
/// 保存CT碼必填字段
/// </summary>
/// <param name="mandatoryF"></param>
/// <returns></returns>
public MandatoryInfo saveManField(MandatoryInfo mandatoryF)
{
MandatoryInfo reMandatory = null;
mandatoryF.Uuid = Auxiliary.Get_UUID();
mandatoryF.Createtime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
mandatoryF.Opuser = Auxiliary.loginName;
if (printM.saveMandatory(mandatoryF))
{
reMandatory = queryRemandatoryInfo(mandatoryF.Uuid);
}
return(reMandatory);
}
/// <summary>
///
/// </summary>
/// <param name="mandatoryInfo"></param>
/// <returns></returns>
public MandatoryInfo saveMandatoryInfo(MandatoryInfo mandatoryInfo)
{
MandatoryInfo reMandatoryInfo = null;
mandatoryInfo.Uuid = Auxiliary.Get_UUID();
mandatoryInfo.Opuser = Auxiliary.loginName;
mandatoryInfo.Createtime = Auxiliary.Get_CurrentTime();
if (mandatoryFieldDao.saveMandatoryInfo(mandatoryInfo))
{
reMandatoryInfo = mandatoryFieldDao.queryMenuInfoById(mandatoryInfo.Uuid);
}
return(reMandatoryInfo);
}
public MandatoryInfo queryRemandatoryInfo(string uuid)
{
MandatoryInfo mandatoryInfo = null;
DataSet ds = printM.queryMandatoryById(uuid);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
mandatoryInfo = new MandatoryInfo();
mandatoryInfo.Uuid = ds.Tables[0].Rows[0]["uuid"].ToString();
mandatoryInfo.Manno = ds.Tables[0].Rows[0]["man_no"].ToString();
mandatoryInfo.Mandesc = ds.Tables[0].Rows[0]["man_desc"].ToString();
mandatoryInfo.Opuser = ds.Tables[0].Rows[0]["op_user"].ToString();
mandatoryInfo.Createtime = ds.Tables[0].Rows[0]["create_time"].ToString();
}
return(mandatoryInfo);
}
/// <summary>
/// 根據UUID查詢
/// </summary>
/// <param name="uuid"></param>
/// <returns></returns>
public MandatoryInfo queryMenuInfoById(string uuid)
{
MandatoryInfo mandatoryInfo = null;
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT uuid,man_no,man_desc,op_user,create_time FROM t_mandatory_info where uuid=@uuid and del_flag is null");
MySqlParameter[] parameters =
{
new MySqlParameter("@uuid", MySqlDbType.VarChar, 900),
};
parameters[0].Value = uuid;
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionString, CommandType.Text, strSql.ToString(), parameters);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
mandatoryInfo = new MandatoryInfo();
mandatoryInfo.Uuid = ds.Tables[0].Rows[0]["uuid"].ToString();
mandatoryInfo.Manno = ds.Tables[0].Rows[0]["man_no"].ToString();
mandatoryInfo.Mandesc = ds.Tables[0].Rows[0]["man_desc"].ToString();
mandatoryInfo.Opuser = ds.Tables[0].Rows[0]["op_user"].ToString();
mandatoryInfo.Createtime = ds.Tables[0].Rows[0]["create_time"].ToString();
}
return(mandatoryInfo);
}
