private static HA_Parameter ToModel(DataRow row)
{
HA_Parameter model = new HA_Parameter();
model.para_name = row.IsNull("para_name") ? null : (String)row["para_name"];
model.para_code = row.IsNull("para_code") ? null : (String)row["para_code"];
model.para_datatype = row.IsNull("para_datatype") ? null : (String)row["para_datatype"];
model.para_length = row.IsNull("para_length") ? null : (String)row["para_length"];
model.para_required = row.IsNull("para_required") ? null : (Boolean?)row["para_required"];
model.para_default = row.IsNull("para_default") ? null : (String)row["para_default"];
model.para_note = row.IsNull("para_note") ? null : (String)row["para_note"];
return(model);
}
public bool Update(HA_Parameter model)
{
string sqlStr = "update HA_Parameter set para_name=@para_name,para_code=@para_code,para_datatype=@para_datatype,para_length=@para_length,para_required=@para_required,para_default=@para_default,para_note=@para_note where para_code=@para_code";
int rows = SQLHelper.ExecuteNonQuery(sqlStr
, new SqlParameter("para_name", model.para_name)
, new SqlParameter("para_code", model.para_code)
, new SqlParameter("para_datatype", model.para_datatype)
, new SqlParameter("para_length", model.para_length)
, new SqlParameter("para_required", model.para_required)
, new SqlParameter("para_default", model.para_default)
, new SqlParameter("para_note", model.para_note)
);
return(rows > 0);
}
public HA_Parameter GetModelById(string id)
{
string sqlStr = "select * from HA_Parameter where para_code=@id";
DataTable dt = SQLHelper.ExecuteDataTable(sqlStr, new SqlParameter("id", id));
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
HA_Parameter model = ToModel(row);
return(model);
}
public int AddNew(HA_Parameter model)
{
string sqlStr = "insert into HA_Parameter(para_name,para_code,para_datatype,para_length," +
"para_required,para_default,para_note) output inserted.para_id " +
" values(@para_name,@para_code,@para_datatype,@para_length," +
"@para_required,@para_default,@para_note)";
int id = (int)SQLHelper.ExecuteScalar(sqlStr
, new SqlParameter("para_name", model.para_name)
, new SqlParameter("para_code", model.para_code)
, new SqlParameter("para_datatype", model.para_datatype)
, new SqlParameter("para_length", model.para_length)
, new SqlParameter("para_required", model.para_required)
, new SqlParameter("para_default", model.para_default)
, new SqlParameter("para_note", model.para_note)
);
return(id);
}
private void skinLVParas_DoubleClick(object sender, EventArgs e)
{
if (skinLVParas.SelectedItems.Count > 0)
{
var a = skinLVParas.SelectedItems[0];
HA_Parameter ha_para = new HA_Parameter
{
para_code = a.SubItems[0].Text,
para_name = a.SubItems[1].Text,
para_datatype = a.SubItems[2].Text,
para_length = a.SubItems[3].Text,
para_default = a.SubItems[4].Text,
para_note = a.SubItems[5].Text,
para_required = false
};
FrmManagePara manageIntfFomr = new FrmManagePara(ha_para);
manageIntfFomr.ShowDialog();
ShowAllParameters();
}
}
public FrmManagePara(HA_Parameter ha_para)
{
paraobj = ha_para;
InitializeComponent();
}
