public void Update(Sps_service ud)
{
MySqlConnection mycon = new MySqlConnection();
mycon.ConnectionString = url;
mycon.Open();
MySqlCommand comm = new MySqlCommand();
comm.CommandText = "update sps_service set Name= @Name,Image=@Image ,Info=@Info where Id =@Id";
comm.Parameters.Add("@Id", MySql.Data.MySqlClient.MySqlDbType.Int32);
comm.Parameters.Add("@Name", MySql.Data.MySqlClient.MySqlDbType.String);
comm.Parameters.Add("@Image", MySql.Data.MySqlClient.MySqlDbType.LongBlob);
comm.Parameters.Add("@Info", MySql.Data.MySqlClient.MySqlDbType.String);
comm.Connection = mycon;
comm.Parameters["@Name"].Value = ud.Name;
comm.Parameters["@Image"].Value = ud.Image;
comm.Parameters["@Info"].Value = ud.Info;
comm.Parameters["@Id"].Value = ud.Id;
int result = comm.ExecuteNonQuery();
if (result > 0)
{
}
}
private Sps_service ToSp_url(DataRow row)
{
Sps_service op = new Sps_service();
op.Id = Convert.ToInt32(row["Id"]);
op.Code = (string)row["Code"];
op.Name = (string)row["Name"];
if (row["Image"] != DBNull.Value)
{
op.Image = (byte[])row["Image"];
}
op.Info = (string)row["Info"];
return(op);
}
private void btnAddService_Click(object sender, EventArgs e)
{
if (tbServiceName.Text.Trim() == "")
{
MessageBox.Show("业务名称不能为空！");
return;
}
Sps_service spUrl = new Sps_service();
spUrl.Name = tbServiceName.Text.Trim();
spUrl.Info = tbServiceInfo.Text.Trim();
spUrl.Image = ImageHelper.ImageToBytes(pbServiceImage.BackgroundImage);
//spUrl.Id = Convert.ToInt32(dtUserTable.SelectedRows[0].Cells["spsUserId"].Value);
if (btnAddService.Text == "新 增")
{
spUrl.Code = "SS_" + GetTimeStamp() + new Random().Next(10000, 99999);
try
{
new Sps_serviceDAL().Insert(spUrl);
MessageBox.Show("添加成功");
ShowServices();
}
catch (Exception ex)
{
MessageBox.Show("添加失败,错误代码为：" + ex.ToString());
}
}
else
{
try
{
spUrl.Id = Convert.ToInt32(dataTabService.SelectedRows[0].Cells["serviceId"].Value);
new Sps_serviceDAL().Update(spUrl);
MessageBox.Show("修改成功");
btnAddService.Text = "新 增";
ShowServices();
}
catch (Exception ex)
{
MessageBox.Show("修改失败,错误代码为：" + ex.ToString());
}
}
}
public void Insert(Sps_service ud)
{
//MySqlConnection mycon = new MySqlConnection();
//mycon.ConnectionString = url;
//string sql2 = string.Format("INSERT into sps_service(Code,Name,Image,Info)values('{1}','{2}',{3},'{4}')", new object[]
// {
// ud.Id,ud.Code,ud.Name,ud.Image,ud.Info
// });
//MySqlCommand comm = new MySqlCommand(sql2, mycon);
//mycon.Open();
//int result = comm.ExecuteNonQuery();
//mycon.Close();
//if (result > 0)
//{
MySqlConnection mycon = new MySqlConnection();
mycon.ConnectionString = url;
mycon.Open();
MySqlCommand comm = new MySqlCommand();
comm.CommandText = "INSERT into sps_service(Code,Name,Image,Info)values(@Code,@Name,@Image,@Info)";
comm.Parameters.Add("@Code", MySql.Data.MySqlClient.MySqlDbType.String);
comm.Parameters.Add("@Name", MySql.Data.MySqlClient.MySqlDbType.String);
comm.Parameters.Add("@Image", MySql.Data.MySqlClient.MySqlDbType.LongBlob);
comm.Parameters.Add("@Info", MySql.Data.MySqlClient.MySqlDbType.String);
comm.Connection = mycon;
comm.Parameters["@Code"].Value = ud.Code;
comm.Parameters["@Name"].Value = ud.Name;
comm.Parameters["@Image"].Value = ud.Image;
comm.Parameters["@Info"].Value = ud.Info;
int result = comm.ExecuteNonQuery();
if (result > 0)
{
}
}