private static HA_Project ToModel(DataRow row)
{
HA_Project model = new HA_Project();
model.proj_name = row.IsNull("proj_name") ? null : (String)row["proj_name"];
model.proj_code = row.IsNull("proj_code") ? null : (String)row["proj_code"];
model.proj_note = row.IsNull("proj_note") ? null : (String)row["proj_note"];
model.proj_port = (Int32)row["proj_port"];
return(model);
}
public bool Update(HA_Project model)
{
string sqlStr = "update HA_Project set proj_name=@proj_name,proj_code=@proj_code," +
"proj_note=@proj_note,proj_port=@proj_port where proj_code=@proj_code";
int rows = SQLHelper.ExecuteNonQuery(sqlStr
, new SqlParameter("proj_name", model.proj_name)
, new SqlParameter("proj_code", model.proj_code)
, new SqlParameter("proj_note", model.proj_note)
, new SqlParameter("proj_port", model.proj_port)
);
return(rows > 0);
}
public int AddNew(HA_Project model)
{
string sqlStr = "insert into HA_Project(proj_name,proj_code,proj_note,proj_port) output inserted.proj_id values" +
"(@proj_name,@proj_code,@proj_note,@proj_port)";
int id = (int)SQLHelper.ExecuteScalar(sqlStr
, new SqlParameter("proj_name", model.proj_name)
, new SqlParameter("proj_code", model.proj_code)
, new SqlParameter("proj_note", model.proj_note)
, new SqlParameter("proj_port", model.proj_port)
);
return(id);
}
private void listVProjects_DoubleClick(object sender, EventArgs e)
{
if (listVProjects.SelectedItems.Count > 0)
{
var a = listVProjects.SelectedItems[0];
HA_Project ha_project = new HA_Project
{
proj_code = a.SubItems[0].Text,
proj_name = a.SubItems[1].Text,
proj_port = Convert.ToInt32(a.SubItems[2].Text),
proj_note = a.SubItems[3].Text
};
FrmManageProj addprojForm = new FrmManageProj(ha_project);
addprojForm.ShowDialog();
ReloadProjects();
}
}
public HA_Project GetModelById(string id)
{
string sqlStr = "select * from HA_Project where proj_code=@proj_code";
DataTable dt = SQLHelper.ExecuteDataTable(sqlStr, new SqlParameter("proj_code", 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_Project model = ToModel(row);
return(model);
}
public FrmManageProj(HA_Project ha_project)
{
projobj = ha_project;
InitializeComponent();
}
