/// <summary>
/// 插入BuyClothes
/// </summary>
public bool Insert(UserOR mobj)
{
string sql = string.Format("insert into [User] (UserName,UserCode,PWD) values ('{0}','{1}','{2}')",
mobj.UserName, mobj.UserCode, mobj.PWD);
return db.excuteNonquery(sql);
}
public UserOR selectARowDate(string m_id)
{
string sql = string.Format("select * from [User] where id={0}", m_id);
DataTable dt = null;
try
{
dt = db.executeQuery(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
UserOR mObj = new UserOR(dr);
return mObj;
}
public UserOR Login(string userCode, string pwd)
{
string sql = string.Format("select * from [User] where UserCode='{0}' and PWD='{1}'", userCode, pwd);
DataTable dt = null;
try
{
dt = db.executeQuery(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
UserOR mObj = new UserOR(dr);
return mObj;
}
public bool Update(UserOR mobj)
{
string sql = string.Format("update [User] set UserName='******',UserCode='{1}',PWD='{2}' where id={3}",
mobj.UserName, mobj.UserCode, mobj.PWD, mobj.ID);
return db.excuteNonquery(sql);
}
private UserOR setValue()
{
if (string.IsNullOrEmpty(txtUserName.Text)
|| string.IsNullOrEmpty(txtAccount.Text)
|| string.IsNullOrEmpty(txtUserPwd.Text)
)
{
MessageBox.Show("数据输入不完整。", "提示");
return null;
}
UserOR m_obj = new UserOR();
m_obj.UserName = txtUserName.Text;
m_obj.UserCode = txtAccount.Text;
m_obj.PWD = txtUserPwd.Text;
return m_obj;
}
