private void map(ComplainInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.SoSysNo = Util.TrimIntNull(tempdr["SoSysNo"]);
oParam.CustomerSysno = Util.TrimIntNull(tempdr["CustomerSysno"]);
oParam.Contact = Util.TrimNull(tempdr["Contact"]);
oParam.ContactPhone = Util.TrimNull(tempdr["ContactPhone"]);
oParam.AreaSysNo = Util.TrimIntNull(tempdr["AreaSysNo"]);
oParam.Address = Util.TrimNull(tempdr["Address"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.LastUpdateUserSysNo = Util.TrimIntNull(tempdr["LastUpdateUserSysNo"]);
oParam.LastUpdateTime = Util.TrimDateNull(tempdr["LastUpdateTime"]);
oParam.CurrentHandleUserSysNo = Util.TrimIntNull(tempdr["CurrentHandleUserSysNo"]);
oParam.AbnormalType = Util.TrimIntNull(tempdr["AbnormalType"]);
oParam.AbnormalCauseType = Util.TrimIntNull(tempdr["AbnormalCauseType"]);
oParam.CustomerNote = Util.TrimNull(tempdr["CustomerNote"]);
oParam.EmployeeNote = Util.TrimNull(tempdr["EmployeeNote"]);
oParam.AuditNote = Util.TrimNull(tempdr["AuditNote"]);
oParam.AuditUserSysNo = Util.TrimIntNull(tempdr["AuditUserSysNo"]);
oParam.AuditTime = Util.TrimDateNull(tempdr["AuditTime"]);
oParam.Score = Util.TrimIntNull(tempdr["Score"]);
oParam.ReviewBackNote = Util.TrimNull(tempdr["ReviewBackNote"]);
oParam.LastReviewBackUserSysNo = Util.TrimIntNull(tempdr["LastReviewBackUserSysNo"]);
oParam.LastReviewTime = Util.TrimDateNull(tempdr["LastReviewTime"]);
oParam.CloseUserSysNo = Util.TrimIntNull(tempdr["CloseUserSysNo"]);
oParam.CloseTime = Util.TrimDateNull(tempdr["CloseTime"]);
}
public void Update(ComplainInfo oParam)
{
new ComplainDac().Update(oParam);
}
public ComplainInfo Load(int sysNo)
{
string sql = "select * from Complain where sysno =" + sysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return null;
ComplainInfo oComplain = new ComplainInfo();
map(oComplain, ds.Tables[0].Rows[0]);
return oComplain;
}
public void Insert(ComplainInfo oParam)
{
new ComplainDac().Insert(oParam);
}
public int Update(ComplainInfo oParam)
{
string sql = @"UPDATE Complain SET
SoSysNo=@SoSysNo, CustomerSysno=@CustomerSysno,
Contact=@Contact, ContactPhone=@ContactPhone,
AreaSysNo=@AreaSysNo, Address=@Address,
CreateUserSysNo=@CreateUserSysNo, CreateTime=@CreateTime,
Status=@Status, LastUpdateUserSysNo=@LastUpdateUserSysNo,
LastUpdateTime=@LastUpdateTime, CurrentHandleUserSysNo=@CurrentHandleUserSysNo,
AbnormalType=@AbnormalType, AbnormalCauseType=@AbnormalCauseType,
CustomerNote=@CustomerNote, EmployeeNote=@EmployeeNote,
AuditNote=@AuditNote, AuditUserSysNo=@AuditUserSysNo,
AuditTime=@AuditTime, Score=@Score,
ReviewBackNote=@ReviewBackNote, LastReviewBackUserSysNo=@LastReviewBackUserSysNo,
LastReviewTime=@LastReviewTime, CloseUserSysNo=@CloseUserSysNo,
CloseTime=@CloseTime
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSoSysNo = new SqlParameter("@SoSysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSysno = new SqlParameter("@CustomerSysno", SqlDbType.Int, 4);
SqlParameter paramContact = new SqlParameter("@Contact", SqlDbType.NVarChar, 50);
SqlParameter paramContactPhone = new SqlParameter("@ContactPhone", SqlDbType.NVarChar, 50);
SqlParameter paramAreaSysNo = new SqlParameter("@AreaSysNo", SqlDbType.Int, 4);
SqlParameter paramAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 200);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramLastUpdateUserSysNo = new SqlParameter("@LastUpdateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramLastUpdateTime = new SqlParameter("@LastUpdateTime", SqlDbType.DateTime);
SqlParameter paramCurrentHandleUserSysNo = new SqlParameter("@CurrentHandleUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAbnormalType = new SqlParameter("@AbnormalType", SqlDbType.Int, 4);
SqlParameter paramAbnormalCauseType = new SqlParameter("@AbnormalCauseType", SqlDbType.Int, 4);
SqlParameter paramCustomerNote = new SqlParameter("@CustomerNote", SqlDbType.Text, 0);
SqlParameter paramEmployeeNote = new SqlParameter("@EmployeeNote", SqlDbType.Text, 0);
SqlParameter paramAuditNote = new SqlParameter("@AuditNote", SqlDbType.Text, 0);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
SqlParameter paramScore = new SqlParameter("@Score", SqlDbType.Int, 4);
SqlParameter paramReviewBackNote = new SqlParameter("@ReviewBackNote", SqlDbType.Text, 0);
SqlParameter paramLastReviewBackUserSysNo = new SqlParameter("@LastReviewBackUserSysNo", SqlDbType.Int, 4);
SqlParameter paramLastReviewTime = new SqlParameter("@LastReviewTime", SqlDbType.DateTime);
SqlParameter paramCloseUserSysNo = new SqlParameter("@CloseUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCloseTime = new SqlParameter("@CloseTime", SqlDbType.DateTime);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.SoSysNo != AppConst.IntNull)
paramSoSysNo.Value = oParam.SoSysNo;
else
paramSoSysNo.Value = System.DBNull.Value;
if (oParam.CustomerSysno != AppConst.IntNull)
paramCustomerSysno.Value = oParam.CustomerSysno;
else
paramCustomerSysno.Value = System.DBNull.Value;
if (oParam.Contact != AppConst.StringNull)
paramContact.Value = oParam.Contact;
else
paramContact.Value = System.DBNull.Value;
if (oParam.ContactPhone != AppConst.StringNull)
paramContactPhone.Value = oParam.ContactPhone;
else
paramContactPhone.Value = System.DBNull.Value;
if (oParam.AreaSysNo != AppConst.IntNull)
paramAreaSysNo.Value = oParam.AreaSysNo;
else
paramAreaSysNo.Value = System.DBNull.Value;
if (oParam.Address != AppConst.StringNull)
paramAddress.Value = oParam.Address;
else
paramAddress.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
if (oParam.LastUpdateUserSysNo != AppConst.IntNull)
paramLastUpdateUserSysNo.Value = oParam.LastUpdateUserSysNo;
else
paramLastUpdateUserSysNo.Value = System.DBNull.Value;
if (oParam.LastUpdateTime != AppConst.DateTimeNull)
paramLastUpdateTime.Value = oParam.LastUpdateTime;
else
paramLastUpdateTime.Value = System.DBNull.Value;
if (oParam.CurrentHandleUserSysNo != AppConst.IntNull)
paramCurrentHandleUserSysNo.Value = oParam.CurrentHandleUserSysNo;
else
paramCurrentHandleUserSysNo.Value = System.DBNull.Value;
if (oParam.AbnormalType != AppConst.IntNull)
paramAbnormalType.Value = oParam.AbnormalType;
else
paramAbnormalType.Value = System.DBNull.Value;
if (oParam.AbnormalCauseType != AppConst.IntNull)
paramAbnormalCauseType.Value = oParam.AbnormalCauseType;
else
paramAbnormalCauseType.Value = System.DBNull.Value;
if (oParam.CustomerNote != AppConst.StringNull)
paramCustomerNote.Value = oParam.CustomerNote;
else
paramCustomerNote.Value = System.DBNull.Value;
if (oParam.EmployeeNote != AppConst.StringNull)
paramEmployeeNote.Value = oParam.EmployeeNote;
else
paramEmployeeNote.Value = System.DBNull.Value;
if (oParam.AuditNote != AppConst.StringNull)
paramAuditNote.Value = oParam.AuditNote;
else
paramAuditNote.Value = System.DBNull.Value;
if (oParam.AuditUserSysNo != AppConst.IntNull)
paramAuditUserSysNo.Value = oParam.AuditUserSysNo;
else
paramAuditUserSysNo.Value = System.DBNull.Value;
if (oParam.AuditTime != AppConst.DateTimeNull)
paramAuditTime.Value = oParam.AuditTime;
else
paramAuditTime.Value = System.DBNull.Value;
if (oParam.Score != AppConst.IntNull)
paramScore.Value = oParam.Score;
else
paramScore.Value = System.DBNull.Value;
if (oParam.ReviewBackNote != AppConst.StringNull)
paramReviewBackNote.Value = oParam.ReviewBackNote;
else
paramReviewBackNote.Value = System.DBNull.Value;
if (oParam.LastReviewBackUserSysNo != AppConst.IntNull)
paramLastReviewBackUserSysNo.Value = oParam.LastReviewBackUserSysNo;
else
paramLastReviewBackUserSysNo.Value = System.DBNull.Value;
if (oParam.LastReviewTime != AppConst.DateTimeNull)
paramLastReviewTime.Value = oParam.LastReviewTime;
else
paramLastReviewTime.Value = System.DBNull.Value;
if (oParam.CloseUserSysNo != AppConst.IntNull)
paramCloseUserSysNo.Value = oParam.CloseUserSysNo;
else
paramCloseUserSysNo.Value = System.DBNull.Value;
if (oParam.CloseTime != AppConst.DateTimeNull)
paramCloseTime.Value = oParam.CloseTime;
else
paramCloseTime.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSoSysNo);
cmd.Parameters.Add(paramCustomerSysno);
cmd.Parameters.Add(paramContact);
cmd.Parameters.Add(paramContactPhone);
cmd.Parameters.Add(paramAreaSysNo);
cmd.Parameters.Add(paramAddress);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramLastUpdateUserSysNo);
cmd.Parameters.Add(paramLastUpdateTime);
cmd.Parameters.Add(paramCurrentHandleUserSysNo);
cmd.Parameters.Add(paramAbnormalType);
cmd.Parameters.Add(paramAbnormalCauseType);
cmd.Parameters.Add(paramCustomerNote);
cmd.Parameters.Add(paramEmployeeNote);
cmd.Parameters.Add(paramAuditNote);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramScore);
cmd.Parameters.Add(paramReviewBackNote);
cmd.Parameters.Add(paramLastReviewBackUserSysNo);
cmd.Parameters.Add(paramLastReviewTime);
cmd.Parameters.Add(paramCloseUserSysNo);
cmd.Parameters.Add(paramCloseTime);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(ComplainInfo oParam)
{
string sql = @"INSERT INTO Complain
(
SoSysNo, CustomerSysno, Contact, ContactPhone,
AreaSysNo, Address, CreateUserSysNo, CreateTime,
Status, LastUpdateUserSysNo, LastUpdateTime, CurrentHandleUserSysNo,
AbnormalType, AbnormalCauseType, CustomerNote, EmployeeNote,
AuditNote, AuditUserSysNo, AuditTime, Score,
ReviewBackNote, LastReviewBackUserSysNo, LastReviewTime, CloseUserSysNo,
CloseTime
)
VALUES (
@SoSysNo, @CustomerSysno, @Contact, @ContactPhone,
@AreaSysNo, @Address, @CreateUserSysNo, @CreateTime,
@Status, @LastUpdateUserSysNo, @LastUpdateTime, @CurrentHandleUserSysNo,
@AbnormalType, @AbnormalCauseType, @CustomerNote, @EmployeeNote,
@AuditNote, @AuditUserSysNo, @AuditTime, @Score,
@ReviewBackNote, @LastReviewBackUserSysNo, @LastReviewTime, @CloseUserSysNo,
@CloseTime
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSoSysNo = new SqlParameter("@SoSysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSysno = new SqlParameter("@CustomerSysno", SqlDbType.Int, 4);
SqlParameter paramContact = new SqlParameter("@Contact", SqlDbType.NVarChar, 50);
SqlParameter paramContactPhone = new SqlParameter("@ContactPhone", SqlDbType.NVarChar, 50);
SqlParameter paramAreaSysNo = new SqlParameter("@AreaSysNo", SqlDbType.Int, 4);
SqlParameter paramAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 200);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
SqlParameter paramLastUpdateUserSysNo = new SqlParameter("@LastUpdateUserSysNo", SqlDbType.Int, 4);
SqlParameter paramLastUpdateTime = new SqlParameter("@LastUpdateTime", SqlDbType.DateTime);
SqlParameter paramCurrentHandleUserSysNo = new SqlParameter("@CurrentHandleUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAbnormalType = new SqlParameter("@AbnormalType", SqlDbType.Int, 4);
SqlParameter paramAbnormalCauseType = new SqlParameter("@AbnormalCauseType", SqlDbType.Int, 4);
SqlParameter paramCustomerNote = new SqlParameter("@CustomerNote", SqlDbType.Text, 0);
SqlParameter paramEmployeeNote = new SqlParameter("@EmployeeNote", SqlDbType.Text, 0);
SqlParameter paramAuditNote = new SqlParameter("@AuditNote", SqlDbType.NVarChar, 200);
SqlParameter paramAuditUserSysNo = new SqlParameter("@AuditUserSysNo", SqlDbType.Int, 4);
SqlParameter paramAuditTime = new SqlParameter("@AuditTime", SqlDbType.DateTime);
SqlParameter paramScore = new SqlParameter("@Score", SqlDbType.Int, 4);
SqlParameter paramReviewBackNote = new SqlParameter("@ReviewBackNote", SqlDbType.Text, 0);
SqlParameter paramLastReviewBackUserSysNo = new SqlParameter("@LastReviewBackUserSysNo", SqlDbType.Int, 4);
SqlParameter paramLastReviewTime = new SqlParameter("@LastReviewTime", SqlDbType.DateTime);
SqlParameter paramCloseUserSysNo = new SqlParameter("@CloseUserSysNo", SqlDbType.Int, 4);
SqlParameter paramCloseTime = new SqlParameter("@CloseTime", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.SoSysNo != AppConst.IntNull)
paramSoSysNo.Value = oParam.SoSysNo;
else
paramSoSysNo.Value = System.DBNull.Value;
if (oParam.CustomerSysno != AppConst.IntNull)
paramCustomerSysno.Value = oParam.CustomerSysno;
else
paramCustomerSysno.Value = System.DBNull.Value;
if (oParam.Contact != AppConst.StringNull)
paramContact.Value = oParam.Contact;
else
paramContact.Value = System.DBNull.Value;
if (oParam.ContactPhone != AppConst.StringNull)
paramContactPhone.Value = oParam.ContactPhone;
else
paramContactPhone.Value = System.DBNull.Value;
if (oParam.AreaSysNo != AppConst.IntNull)
paramAreaSysNo.Value = oParam.AreaSysNo;
else
paramAreaSysNo.Value = System.DBNull.Value;
if (oParam.Address != AppConst.StringNull)
paramAddress.Value = oParam.Address;
else
paramAddress.Value = System.DBNull.Value;
if (oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
if (oParam.CreateTime != AppConst.DateTimeNull)
paramCreateTime.Value = oParam.CreateTime;
else
paramCreateTime.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
if (oParam.LastUpdateUserSysNo != AppConst.IntNull)
paramLastUpdateUserSysNo.Value = oParam.LastUpdateUserSysNo;
else
paramLastUpdateUserSysNo.Value = System.DBNull.Value;
if (oParam.LastUpdateTime != AppConst.DateTimeNull)
paramLastUpdateTime.Value = oParam.LastUpdateTime;
else
paramLastUpdateTime.Value = System.DBNull.Value;
if (oParam.CurrentHandleUserSysNo != AppConst.IntNull)
paramCurrentHandleUserSysNo.Value = oParam.CurrentHandleUserSysNo;
else
paramCurrentHandleUserSysNo.Value = System.DBNull.Value;
if (oParam.AbnormalType != AppConst.IntNull)
paramAbnormalType.Value = oParam.AbnormalType;
else
paramAbnormalType.Value = System.DBNull.Value;
if (oParam.AbnormalCauseType != AppConst.IntNull)
paramAbnormalCauseType.Value = oParam.AbnormalCauseType;
else
paramAbnormalCauseType.Value = System.DBNull.Value;
if (oParam.CustomerNote != AppConst.StringNull)
paramCustomerNote.Value = oParam.CustomerNote;
else
paramCustomerNote.Value = System.DBNull.Value;
if (oParam.EmployeeNote != AppConst.StringNull)
paramEmployeeNote.Value = oParam.EmployeeNote;
else
paramEmployeeNote.Value = System.DBNull.Value;
if (oParam.AuditNote != AppConst.StringNull)
paramAuditNote.Value = oParam.AuditNote;
else
paramAuditNote.Value = System.DBNull.Value;
if (oParam.AuditUserSysNo != AppConst.IntNull)
paramAuditUserSysNo.Value = oParam.AuditUserSysNo;
else
paramAuditUserSysNo.Value = System.DBNull.Value;
if (oParam.AuditTime != AppConst.DateTimeNull)
paramAuditTime.Value = oParam.AuditTime;
else
paramAuditTime.Value = System.DBNull.Value;
if (oParam.Score != AppConst.IntNull)
paramScore.Value = oParam.Score;
else
paramScore.Value = System.DBNull.Value;
if (oParam.ReviewBackNote != AppConst.StringNull)
paramReviewBackNote.Value = oParam.ReviewBackNote;
else
paramReviewBackNote.Value = System.DBNull.Value;
if (oParam.LastReviewBackUserSysNo != AppConst.IntNull)
paramLastReviewBackUserSysNo.Value = oParam.LastReviewBackUserSysNo;
else
paramLastReviewBackUserSysNo.Value = System.DBNull.Value;
if (oParam.LastReviewTime != AppConst.DateTimeNull)
paramLastReviewTime.Value = oParam.LastReviewTime;
else
paramLastReviewTime.Value = System.DBNull.Value;
if (oParam.CloseUserSysNo != AppConst.IntNull)
paramCloseUserSysNo.Value = oParam.CloseUserSysNo;
else
paramCloseUserSysNo.Value = System.DBNull.Value;
if (oParam.CloseTime != AppConst.DateTimeNull)
paramCloseTime.Value = oParam.CloseTime;
else
paramCloseTime.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSoSysNo);
cmd.Parameters.Add(paramCustomerSysno);
cmd.Parameters.Add(paramContact);
cmd.Parameters.Add(paramContactPhone);
cmd.Parameters.Add(paramAreaSysNo);
cmd.Parameters.Add(paramAddress);
cmd.Parameters.Add(paramCreateUserSysNo);
cmd.Parameters.Add(paramCreateTime);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramLastUpdateUserSysNo);
cmd.Parameters.Add(paramLastUpdateTime);
cmd.Parameters.Add(paramCurrentHandleUserSysNo);
cmd.Parameters.Add(paramAbnormalType);
cmd.Parameters.Add(paramAbnormalCauseType);
cmd.Parameters.Add(paramCustomerNote);
cmd.Parameters.Add(paramEmployeeNote);
cmd.Parameters.Add(paramAuditNote);
cmd.Parameters.Add(paramAuditUserSysNo);
cmd.Parameters.Add(paramAuditTime);
cmd.Parameters.Add(paramScore);
cmd.Parameters.Add(paramReviewBackNote);
cmd.Parameters.Add(paramLastReviewBackUserSysNo);
cmd.Parameters.Add(paramLastReviewTime);
cmd.Parameters.Add(paramCloseUserSysNo);
cmd.Parameters.Add(paramCloseTime);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
