public int AddChance(Model.Chances chances) { chances.ChanCreateDate = DateTime.Now; int id = -1; if (DalBase.Insert(chances) > 0) { id = Convert.ToInt32(DalBase.GetMax <Model.Chances>()); } return(id); }
public int UpdChanDue(Model.Chances chance) { chance.ChanDueDate = DateTime.Now; return(DalBase.Updata(chance)); }
public int UpdChance(Model.Chances chances) { //机会创建人id string sql = string.Format(@"select ChanCreateMan from Chances where ChanID=@ChanID"); SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@ChanID", chances.ChanID) }; int crid = DalBase.SelectObj(sql, sp); //查询机会状态 string sql5 = string.Format(@"select ChanState from Chances where ChanID=@ChanID"); SqlParameter[] sp5 = new SqlParameter[] { new SqlParameter("@ChanID", chances.ChanID) }; int csid = DalBase.SelectObj(sql5, sp5); int cdid = 0; if (csid != 1) { //机会指派人id string sql3 = string.Format(@"select ChanDueMan from Chances where ChanID=@ChanID"); SqlParameter[] sp3 = new SqlParameter[] { new SqlParameter("@ChanID", chances.ChanID) }; cdid = DalBase.SelectObj(sql3, sp3); } //当前登录人id string UserLName = Session["UserLName"].ToString(); string sql1 = string.Format(@"select UserID from Users where UserLName=@UserLName"); SqlParameter[] sp1 = new SqlParameter[] { new SqlParameter("@UserLName", UserLName) }; int uid = DalBase.SelectObj(sql1, sp1); //当前登录人角色id string sql2 = string.Format(@"select RoleID from Users where UserLName=@UserLName"); SqlParameter[] sp2 = new SqlParameter[] { new SqlParameter("@UserLName", UserLName) }; int rid = DalBase.SelectObj(sql2, sp2); if (rid <= 2) { DalBase.Updata(chances); } else if (rid == 3) { if (crid == uid) { DalBase.Updata(chances); } else if (cdid == uid) { DalBase.Updata(chances); } else { return(-1); } } return(1); }