private Sps_user ToSp_url(DataRow row)
{
Sps_user op = new Sps_user();
op.Id = Convert.ToInt32(row["Id"]);
op.Account = (string)row["Account"];
try
{
op.EMail = (string)row["EMail"];
}
catch
{
op.EMail = "";
}
try
{
op.Alias = (string)row["Alias"];
}
catch
{
op.Alias = "";
}
try
{
op.Address = (string)row["Address"];
}
catch
{
op.Address = "";
}
try
{
op.OrgName = (string)row["OrgName"];
}
catch
{
op.OrgName = "";
}
//op.Lantudite = (float)row["Lantudite"];
//op.Longdite = (float)row["Longdite"];
return(op);
}
private void btnAddUser_Click(object sender, EventArgs e)
{
if (tbAccount.Text.Trim() == "" || tbAlias.Text.Trim() == "")
{
MessageBox.Show("账户和账户名不能为空！");
return;
}
Sps_user spUrl = new Sps_user();
spUrl.Account = tbAccount.Text.Trim();
spUrl.EMail = tbEMail.Text.Trim();
spUrl.Alias = tbAlias.Text.Trim();
spUrl.Address = tbAddress.Text.Trim();
spUrl.Lantudite = float.Parse(tbLant.Text.Trim());
spUrl.Longdite = float.Parse(tbLong.Text.Trim());
spUrl.OrgName = tbOrgName.Text.Trim();
if (btnAddUser.Text == "新 增")
{
try
{
new Sps_userDAL().Insert(spUrl);
MessageBox.Show("添加成功");
ShowUsers();
}
catch (Exception ex)
{
MessageBox.Show("添加失败,错误代码为：" + ex.ToString());
}
}
else
{
try
{
spUrl.Id = Convert.ToInt32(dtUserTable.SelectedRows[0].Cells["spsUserId"].Value);
new Sps_userDAL().Update(spUrl);
MessageBox.Show("修改成功");
btnAddUser.Text = "新 增";
ShowUsers();
}
catch (Exception ex)
{
MessageBox.Show("修改失败,错误代码为：" + ex.ToString());
}
}
}
public void Update(Sps_user ud)
{
MySqlConnection mycon = new MySqlConnection();
mycon.ConnectionString = url;
string sql2 = string.Format("update sps_user set EMail='" + ud.EMail + "',Alias='" + ud.Alias + "',Address='" + ud.Address + "',OrgName='"
+ ud.OrgName + "',Lantudite=" + ud.Lantudite + ",Longdite=" + ud.Longdite + " where Account ='" + ud.Account + "'");
MySqlCommand comm = new MySqlCommand(sql2, mycon);
mycon.Open();
int result = comm.ExecuteNonQuery();
mycon.Close();
if (result > 0)
{
}
}
public void Insert(Sps_user ud)
{
MySqlConnection mycon = new MySqlConnection();
mycon.ConnectionString = url;
string sql2 = string.Format("INSERT into sps_user(Account,EMail,Alias,Address,OrgName,Lantudite,Longdite)values('{1}','{2}','{3}','{4}','{5}',{6},{7})", new object[]
{
ud.Id, ud.Account, ud.EMail, ud.Alias, ud.Address, ud.OrgName, ud.Lantudite, ud.Longdite
});
MySqlCommand comm = new MySqlCommand(sql2, mycon);
mycon.Open();
int result = comm.ExecuteNonQuery();
mycon.Close();
if (result > 0)
{
}
}