public void SaveUserEntity(UserEntity user, string olduserid, MaintainBasicInfo.OperState oper) { DrectSoft.Core.GenerateShortCode d = new GenerateShortCode(m_app.SqlHelper); string[] code = d.GenerateStringShortCode(user.Name); string py = code[0]; string wb = code[1]; string passwd = "QK+S40FfCEQ="; string regdate = "2005110717:30:35"; string sql = ""; switch (oper) { case MaintainBasicInfo.OperState.ADD: sql = @"Insert into users(ID, NAME,PY,WB,SEXY,BIRTH,MARITAL,idno,DEPTID,WARDID,PASSWD,REGDATE,valid) values ('" + user.ID + "','" + user.Name + "','" + py + "','" + wb + "','" + user.Sex + "','" + user.Birthday.ToShortDateString() + "','" + user.Marital + "','" + user.CardID + "','" + user.DeptID + "','" + user.WardID + "','" + passwd + "','" + regdate + "'," + 1 + ")"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; case MaintainBasicInfo.OperState.EDIT: sql = @"UPDATE users SET Name='" + user.Name + "',Py='" + py + "',Wb='" + wb + "',DeptId='" + user.DeptID + "',WardID='" + user.WardID + "',Marital='" + user.Marital + "',Sexy='" + user.Sex + "',Birth='" + user.Birthday.ToShortDateString() + "',IDNO='" + user.CardID + "',ID='" + user.ID + "' WHERE ID='" + olduserid + "'"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; case MaintainBasicInfo.OperState.DEL: sql = @"update users set valid = 0 where id = '" + user.ID + "'"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; } }
public void SaveDeptEntity(DeptEntity dept, MaintainBasicInfo.OperState oper) { DrectSoft.Core.GenerateShortCode d = new GenerateShortCode(m_app.SqlHelper); string[] code = d.GenerateStringShortCode(dept.Name); string py = code[0]; string wb = code[1]; string sql = ""; switch (oper) { case MaintainBasicInfo.OperState.ADD: sql = @"Insert into department(ID, NAME,PY,WB,HOSNO,ADEPT,BDEPT,SORT,MARK,VALID) values ('" + dept.ID + "','" + dept.Name + "','" + py + "','" + wb + "', '01','',''," + dept.SortID + ",201,1)"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; case MaintainBasicInfo.OperState.EDIT: sql = @"update department set name = '" + dept.Name + "', py = '" + py + "', wb = '" + wb + "', sort = " + dept.SortID + " where id = '" + dept.ID + "'"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; case MaintainBasicInfo.OperState.DEL: sql = @"update department set valid = 0 where id = '" + dept.ID + "'"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; } }
public void SaveWardEntity(WardEntity ward, MaintainBasicInfo.OperState oper) { DrectSoft.Core.GenerateShortCode d = new GenerateShortCode(m_app.SqlHelper); string[] code = d.GenerateStringShortCode(ward.Name); string py = code[0]; string wb = code[1]; string sql = ""; switch (oper) { case MaintainBasicInfo.OperState.ADD: sql = @"Insert into ward(ID, NAME,PY,WB,MARK,VALID) values ('" + ward.ID + "','" + ward.Name + "','" + py + "','" + wb + "',300,1)"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; case MaintainBasicInfo.OperState.EDIT: sql = @"update ward set name = '" + ward.Name + "',py = '" + py + "',wb = '" + wb + "' where id = '" + ward.ID + "'"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; case MaintainBasicInfo.OperState.DEL: sql = @"update ward set valid = 0 where id = '" + ward.ID + "'"; m_app.SqlHelper.ExecuteNoneQuery(sql); break; } }