/// <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; }