public List<SysParameterModel> GetSysParameter(SysParameterModel mParameter, ObjectControls oCtrl)
{
string sql = "SELECT A.PARAM_ID,A.PARAM_NO,A.PARAM_NAME,A.PARAM_DESC,A.VALUE1,A.VALUE2,A.VALUE3 FROM SYS_PARAMETER A WHERE 1=1";
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByParameterId) && oCtrl.Append(ref sql, " AND A.PARAM_ID=" + mParameter.ParamId));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByParameterNo) && oCtrl.Append(ref sql, " AND A.PARAM_NO=" + mParameter.ParamNo));
oCtrl.Helper(oCtrl.Exsit(MCtrl.ByParameterName) && oCtrl.Append(ref sql, " AND A.PARAM_NAME=" + mParameter.ParamName));
sdr = ExecuteReader(sql);
List<SysParameterModel> listParameter = new List<SysParameterModel>();
using (sdr)
{
while (sdr.Read())
{
SysParameterModel mSysParameterInfo = new SysParameterModel();
mSysParameterInfo.ParamId = ToInt32(sdr["PARAM_ID"]);
mSysParameterInfo.ParamNo = ToString(sdr["PARAM_NO"]);
mSysParameterInfo.ParamName = ToString(sdr["PARAM_NAME"]);
mSysParameterInfo.ParamDesc = ToString(sdr["PARAM_DESC"]);
mSysParameterInfo.Value1 = ToString(sdr["VALUE1"]);
mSysParameterInfo.Value2 = ToString(sdr["VALUE2"]);
mSysParameterInfo.Value3 = ToString(sdr["VALUE3"]);
listParameter.Add(mSysParameterInfo);
}
}
return listParameter;
}
public int UpdateParameter(SysParameterModel mParameter, ObjectControls oCtrl)
{
string sql = "UPDATE SYS_PARAMETER SET PARAM_NO=PARAM_NO ";
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetValue1) && oCtrl.Append(ref sql, ",VALUE1=" + SQL(mParameter.Value1)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetValue2) && oCtrl.Append(ref sql, ",VALUE2=" + SQL(mParameter.Value2)));
oCtrl.Helper(oCtrl.Exsit(MCtrl.SetValue3) && oCtrl.Append(ref sql, ",VALUE3=" + SQL(mParameter.Value3)));
sql += " WHERE PARAM_ID=" + mParameter.ParamId;
return ExcuteNonQuery(sql);
}
public int UpdateParameter(SysParameterModel mParameter, ObjectControls oCtrl)
{
return dSysParameter.UpdateParameter(mParameter, oCtrl);
}
private void dgvParamList_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null && ParamValue == dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString())
{
return;
}
if (e.ColumnIndex == 3 && !string.IsNullOrEmpty(ParamValue) && (dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null || dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString().Trim().Equals("")))
{
cmn.Show("当前值不能修改为空!");
dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = ParamValue;
return;
}
if (!cmn.Confirm("修改当前行的值?"))
{
dgvParamList.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = ParamValue;
}
else
{
SysParameterModel mParamter = new SysParameterModel();
mParamter.ParamId = int.Parse(dgvParamList.Rows[e.RowIndex].Cells["ParamId"].Value.ToString());
mParamter.Value1 = dgvParamList.Rows[e.RowIndex].Cells["Value1"].Value.ToString().ToUpper();
mParamter.Value2 = dgvParamList.Rows[e.RowIndex].Cells["Value2"].Value == null ? "" : dgvParamList.Rows[e.RowIndex].Cells["Value2"].Value.ToString().ToUpper();
mParamter.Value3 = dgvParamList.Rows[e.RowIndex].Cells["Value3"].Value == null ? "" : dgvParamList.Rows[e.RowIndex].Cells["Value3"].Value.ToString().ToUpper();
oCtrl.Reset();
oCtrl.Add(MCtrl.SetValue1);
oCtrl.Add(MCtrl.SetValue2);
oCtrl.Add(MCtrl.SetValue3);
bParam.UpdateParameter(mParamter, oCtrl);
}
}
//public List<SysParameterModel> GetParameterList(SysParameterModel mParameter)
//{
// var query = dc.SYS_PARAMETER.Where(c => c.PARAM_NO == mParameter.ParamNo);
// List<SysParameterModel> listParameter = new List<SysParameterModel>();
// Log.WriteLog(dc, query, AbBaseBll.IsWriteSql);
// foreach (SYS_PARAMETER sp in query)
// {
// SysParameterModel mSysParameterNew = new SysParameterModel();
// mSysParameterNew.ParamId = sp.PARAM_ID;
// mSysParameterNew.ParamName = sp.PARAM_NAME;
// mSysParameterNew.ParamNo = sp.PARAM_NO;
// mSysParameterNew.Value1 = sp.VALUE1;
// mSysParameterNew.Value2 = sp.VALUE2;
// mSysParameterNew.Value3 = sp.VALUE3;
// listParameter.Add(mSysParameterNew);
// }
// return listParameter;
//}
/// <summary>
/// 获取系统设置参数表
/// </summary>
/// <param name="mParameter"></param>
/// <param name="oCtrl"></param>
/// <returns></returns>
public List<SysParameterModel> GetSysParameter(SysParameterModel mParameter, ObjectControls oCtrl)
{
return dSysParameter.GetSysParameter(mParameter, oCtrl);
}
