/// <summary>
/// 插入控制参数信息
/// </summary>
/// <param name="controlParam"></param>
/// <returns></returns>
public int Insert(ControlParam controlParam)
{
string sql = "insert into com_controlargument(control_code,control_name,control_value,visible_flag,kind,controltype,controlvalue,oper_code,oper_date) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',TO_DATE('{8}','YYYY-MM-DD HH24:MI:SS'))";
sql = string.Format(sql, controlParam.ID, controlParam.Name, controlParam.ParamValue, controlParam.ParamState, controlParam.ParamKind, controlParam.ParamControlKind, controlParam.ParamControlValue, controlParam.Oper, controlParam.OperDate);
return(this.ExecNoQuery(sql));
}
/// <summary>
/// 更新控制参数信息
/// </summary>
/// <param name="controlParam"></param>
/// <returns></returns>
public int update(ControlParam controlParam)
{
string sql = "update com_controlargument t set t.control_name='{1}',t.control_value='{2}',t.visible_flag='{3}',t.kind='{4}',t.controltype='{5}',t.controlvalue='{6}',t.oper_code='{7}',t.oper_date=TO_DATE('{8}','YYYY-MM-DD HH24:MI:SS') where t.control_code='{0}' ";
sql = string.Format(sql, controlParam.ID, controlParam.Name, controlParam.ParamValue, controlParam.ParamState, controlParam.ParamKind, controlParam.ParamControlKind, controlParam.ParamControlValue, controlParam.Oper, controlParam.OperDate);
return(this.ExecNoQuery(sql));
}
/// <summary>
/// 为参数列表赋值
/// </summary>
/// <param name="commonReader"></param>
/// <returns></returns>
private List <ControlParam> GetEnity(System.Data.IDataReader commonReader)
{
List <ControlParam> newList = new List <ControlParam>();
while (commonReader.Read())
{
ControlParam controlParam = new ControlParam();
controlParam.ID = commonReader[0].ToString();
controlParam.Name = commonReader[1].ToString();
controlParam.ParamValue = commonReader[2].ToString();
controlParam.ParamState = commonReader[3].ToString();
controlParam.ParamKind = commonReader[4].ToString();
controlParam.ParamControlKind = commonReader[5].ToString();
controlParam.ParamControlValue = commonReader[6].ToString();
controlParam.Oper = commonReader[7].ToString();
controlParam.OperDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(commonReader[8].ToString());
newList.Add(controlParam);
}
return(newList);
}