public void Add(string userid, string supcode, string supname)
{
ArrayList userinfo = (ArrayList)Session["user"];
SupUsersRelation model = new SupUsersRelation();
model.SUPCODE = supcode;
model.SUPNAEM = supname;
model.USERID = Convert.ToInt32(userid);
model.CREATEMAN = userinfo[0].ToString().Trim();
model.CREATEDATE = DateTime.Now;
string res = surdal.Add(model);
MessageBox.Show(this, res);
}
public string Add(SupUsersRelation item)
{
string datetime = DateTime.Now.ToString("yyy-MM-dd HH:mm:ss");
string sql = "INSERT INTO SUPUSERSRELATION (USERID,SUPCODE,SUPNAEM,CREATEMAN,CREATEDATE) VALUES (" + item.USERID + ",'" + item.SUPCODE + "','" + item.SUPNAEM + "','" + item.CREATEMAN + "',TO_DATE('" + datetime + "','yyyy-MM-dd HH24:MI:SS'))";
using (DbHelperOra _ora = new DbHelperOra(ConnName))
{
int result = _ora.ExecuteSql(sql);
if (result > 0)
{
return("操作成功");
}
else
{
return("操作失败");
}
}
}
