public int DataDelete(CaseOwnerModifyReq req) { int count = 0; using (DbCommand cmd = Db.CreateConnection().CreateCommand()) { string sql = @" DELETE FROM CASE_OWNER WHERE SN=@SN; "; cmd.CommandType = CommandType.Text; cmd.CommandText = sql; Db.AddInParameter(cmd, "SN", DbType.String, req.CASE_OWNER.SN); count = Db.ExecuteNonQuery(cmd); } return(count); }
public int DataCreate(CaseOwnerModifyReq req) { int count = 0; using (DbCommand cmd = Db.CreateConnection().CreateCommand()) { string sql = @" INSERT CASE_OWNER (NAME1,NAME2,NAME3,NAME4,NAME5,NAME6,TEL1,TEL2,TEL3,TEL4,TEL5,TEL6,YEARS_OLD,ADDRESS,TEACHER1,TEACHER2,TEACHER3,FAMILY,RESIDENCE,NOTE,PROBLEM,EXPERIENCE,SUGGEST,CDATE,CUSER,MDATE,MUSER) VALUES (@NAME1,@NAME2,@NAME3,@NAME4,@NAME5,@NAME6,@TEL1,@TEL2,@TEL3,@TEL4,@TEL5,@TEL6,@YEARS_OLD,@ADDRESS,@TEACHER1,@TEACHER2,@TEACHER3,@FAMILY,@RESIDENCE,@NOTE,@PROBLEM,@EXPERIENCE,@SUGGEST,GETDATE(),@CUSER,GETDATE(),@MUSER) SET @SN = SCOPE_IDENTITY(); "; cmd.CommandType = CommandType.Text; cmd.CommandText = sql; Db.AddInParameter(cmd, "NAME1", DbType.String, req.CASE_OWNER.NAME1); Db.AddInParameter(cmd, "NAME2", DbType.String, req.CASE_OWNER.NAME2); Db.AddInParameter(cmd, "NAME3", DbType.String, req.CASE_OWNER.NAME3); Db.AddInParameter(cmd, "NAME4", DbType.String, req.CASE_OWNER.NAME4); Db.AddInParameter(cmd, "NAME5", DbType.String, req.CASE_OWNER.NAME5); Db.AddInParameter(cmd, "NAME6", DbType.String, req.CASE_OWNER.NAME6); Db.AddInParameter(cmd, "TEL1", DbType.String, req.CASE_OWNER.TEL1); Db.AddInParameter(cmd, "TEL2", DbType.String, req.CASE_OWNER.TEL2); Db.AddInParameter(cmd, "TEL3", DbType.String, req.CASE_OWNER.TEL3); Db.AddInParameter(cmd, "TEL4", DbType.String, req.CASE_OWNER.TEL4); Db.AddInParameter(cmd, "TEL5", DbType.String, req.CASE_OWNER.TEL5); Db.AddInParameter(cmd, "TEL6", DbType.String, req.CASE_OWNER.TEL6); Db.AddInParameter(cmd, "YEARS_OLD", DbType.String, req.CASE_OWNER.YEARS_OLD); Db.AddInParameter(cmd, "ADDRESS", DbType.String, req.CASE_OWNER.ADDRESS); Db.AddInParameter(cmd, "TEACHER1", DbType.String, req.CASE_OWNER.TEACHER1); Db.AddInParameter(cmd, "TEACHER2", DbType.String, req.CASE_OWNER.TEACHER2); Db.AddInParameter(cmd, "TEACHER3", DbType.String, req.CASE_OWNER.TEACHER3); Db.AddInParameter(cmd, "FAMILY", DbType.String, req.CASE_OWNER.FAMILY); Db.AddInParameter(cmd, "RESIDENCE", DbType.String, req.CASE_OWNER.RESIDENCE); Db.AddInParameter(cmd, "NOTE", DbType.String, req.CASE_OWNER.NOTE); Db.AddInParameter(cmd, "PROBLEM", DbType.String, req.CASE_OWNER.PROBLEM); Db.AddInParameter(cmd, "EXPERIENCE", DbType.String, req.CASE_OWNER.EXPERIENCE); Db.AddInParameter(cmd, "SUGGEST", DbType.String, req.CASE_OWNER.SUGGEST); Db.AddInParameter(cmd, "CUSER", DbType.String, req.CASE_OWNER.CUSER); Db.AddInParameter(cmd, "MUSER", DbType.String, req.CASE_OWNER.MUSER); Db.AddOutParameter(cmd, "SN", DbType.Int32, 1); count = Db.ExecuteNonQuery(cmd); req.CASE_OWNER.SN = Db.GetParameterValue(cmd, "SN") as Int32? ?? null; } return(count); }
public int DataUpdate(CaseOwnerModifyReq req) { int count = 0; using (DbCommand cmd = Db.CreateConnection().CreateCommand()) { string sql = @" UPDATE CASE_OWNER SET SN=@SN,NAME1=@NAME1,NAME2=@NAME2,NAME3=@NAME3,NAME4=@NAME4,NAME5=@NAME5,NAME6=@NAME6,TEL1=@TEL1,TEL2=@TEL2,TEL3=@TEL3,TEL4=@TEL4,TEL5=@TEL5,TEL6=@TEL6,YEARS_OLD=@YEARS_OLD,ADDRESS=@ADDRESS,FAMILY=@FAMILY,EXPERIENCE=@EXPERIENCE,SUGGEST=@SUGGEST WHERE SN=@SN; "; cmd.CommandType = CommandType.Text; cmd.CommandText = sql; Db.AddInParameter(cmd, "SN", DbType.String, req.CASE_OWNER.SN); Db.AddInParameter(cmd, "NAME1", DbType.String, req.CASE_OWNER.NAME1); Db.AddInParameter(cmd, "NAME2", DbType.String, req.CASE_OWNER.NAME2); Db.AddInParameter(cmd, "NAME3", DbType.String, req.CASE_OWNER.NAME3); Db.AddInParameter(cmd, "NAME4", DbType.String, req.CASE_OWNER.NAME4); Db.AddInParameter(cmd, "NAME5", DbType.String, req.CASE_OWNER.NAME5); Db.AddInParameter(cmd, "NAME6", DbType.String, req.CASE_OWNER.NAME6); Db.AddInParameter(cmd, "TEL1", DbType.String, req.CASE_OWNER.TEL1); Db.AddInParameter(cmd, "TEL2", DbType.String, req.CASE_OWNER.TEL2); Db.AddInParameter(cmd, "TEL3", DbType.String, req.CASE_OWNER.TEL3); Db.AddInParameter(cmd, "TEL4", DbType.String, req.CASE_OWNER.TEL4); Db.AddInParameter(cmd, "TEL5", DbType.String, req.CASE_OWNER.TEL5); Db.AddInParameter(cmd, "TEL6", DbType.String, req.CASE_OWNER.TEL6); Db.AddInParameter(cmd, "YEARS_OLD", DbType.String, req.CASE_OWNER.YEARS_OLD); Db.AddInParameter(cmd, "ADDRESS", DbType.String, req.CASE_OWNER.ADDRESS); Db.AddInParameter(cmd, "FAMILY", DbType.String, req.CASE_OWNER.FAMILY); Db.AddInParameter(cmd, "EXPERIENCE", DbType.String, req.CASE_OWNER.EXPERIENCE); Db.AddInParameter(cmd, "SUGGEST", DbType.String, req.CASE_OWNER.SUGGEST); count = Db.ExecuteNonQuery(cmd); } return(count); }