private void btnSave_Click(object sender, EventArgs e)
{
if (common.photomode == "update")
{
Maticsoft.Model.Photo model = photo.GetModel(int.Parse(common.photoid));
try
{
model.Name = txtName.Text;
model.OrderNum = int.Parse(numericUpDown1.Value.ToString());
model.Type = cobType.Text;
model.Belong = cobBelong.Text;
model.AddUser = common.loginuser;
model.AddTime = DateTime.Now;
if (img)
{
// picurl = txtUrl.Text;
string serverpath = string.Empty;
progressBar1.Visible = true;
common.UploadFile(txtUrl.Text, progressBar1, label1, out serverpath, false,false);
progressBar1.Visible = false;
label1.Text = "";
model.ImgUrl = serverpath;
}
photo.Update(model);
MessageBox.Show("保存成功");
}
catch { MessageBox.Show("保存失败"); }
}
else
{
Maticsoft.Model.Photo model = new Maticsoft.Model.Photo();
try
{
model.Name = txtName.Text;
model.OrderNum = int.Parse(numericUpDown1.Value.ToString());
model.Type = cobType.Text;
model.Belong = cobBelong.Text;
model.AddUser = common.loginuser;
model.AddTime = DateTime.Now;
if (img)
{
// picurl = txtUrl.Text;
string serverpath = string.Empty;
progressBar1.Visible = true;
common.UploadFile(txtUrl.Text, progressBar1, label1, out serverpath, false,false);
progressBar1.Visible = false;
label1.Text = "";
model.ImgUrl = serverpath;
}
photo.Add(model);
MessageBox.Show("保存成功");
}
catch { MessageBox.Show("保存失败"); }
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Photo DataRowToModel(DataRow row)
{
Maticsoft.Model.Photo model=new Maticsoft.Model.Photo();
if (row != null)
{
if(row["ID"]!=null && row["ID"].ToString()!="")
{
model.ID=int.Parse(row["ID"].ToString());
}
if(row["ImgUrl"]!=null)
{
model.ImgUrl=row["ImgUrl"].ToString();
}
if(row["Belong"]!=null)
{
model.Belong=row["Belong"].ToString();
}
if(row["AddUser"]!=null)
{
model.AddUser=row["AddUser"].ToString();
}
if(row["AddTime"]!=null && row["AddTime"].ToString()!="")
{
model.AddTime=DateTime.Parse(row["AddTime"].ToString());
}
if(row["Type"]!=null)
{
model.Type=row["Type"].ToString();
}
if(row["Name"]!=null)
{
model.Name=row["Name"].ToString();
}
if(row["OrderNum"]!=null && row["OrderNum"].ToString()!="")
{
model.OrderNum=int.Parse(row["OrderNum"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.Photo GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,ImgUrl,Belong,AddUser,AddTime,Type,Name,OrderNum from Photo ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)
};
parameters[0].Value = ID;
Maticsoft.Model.Photo model=new Maticsoft.Model.Photo();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
