public int Insert(CustomerCommendInfo oParam) { string sql = @"INSERT INTO Customer_Commend ( CustomerSysNo, FriendName, CommendEmail, CommendTime, CommendStatus ) VALUES ( @CustomerSysNo, @FriendName, @CommendEmail, @CommendTime, @CommendStatus );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4); SqlParameter paramFriendName = new SqlParameter("@FriendName", SqlDbType.NVarChar, 200); SqlParameter paramCommendEmail = new SqlParameter("@CommendEmail", SqlDbType.NVarChar, 200); SqlParameter paramCommendTime = new SqlParameter("@CommendTime", SqlDbType.DateTime); SqlParameter paramCommendStatus = new SqlParameter("@CommendStatus", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.CustomerSysNo != AppConst.IntNull) paramCustomerSysNo.Value = oParam.CustomerSysNo; else paramCustomerSysNo.Value = System.DBNull.Value; if (oParam.FriendName != AppConst.StringNull) paramFriendName.Value = oParam.FriendName; else paramFriendName.Value = System.DBNull.Value; if (oParam.CommendEmail != AppConst.StringNull) paramCommendEmail.Value = oParam.CommendEmail; else paramCommendEmail.Value = System.DBNull.Value; if (oParam.CommendTime != AppConst.DateTimeNull) paramCommendTime.Value = oParam.CommendTime; else paramCommendTime.Value = System.DBNull.Value; if (oParam.CommendStatus != AppConst.IntNull) paramCommendStatus.Value = oParam.CommendStatus; else paramCommendStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramCustomerSysNo); cmd.Parameters.Add(paramFriendName); cmd.Parameters.Add(paramCommendEmail); cmd.Parameters.Add(paramCommendTime); cmd.Parameters.Add(paramCommendStatus); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public int Update(CustomerCommendInfo oParam) { string sql = @"UPDATE Customer_Commend SET CustomerSysNo=@CustomerSysNo, FriendName=@FriendName, CommendEmail=@CommendEmail, CommendTime=@CommendTime, CommendStatus=@CommendStatus WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4); SqlParameter paramFriendName = new SqlParameter("@FriendName", SqlDbType.NVarChar, 200); SqlParameter paramCommendEmail = new SqlParameter("@CommendEmail", SqlDbType.NVarChar, 200); SqlParameter paramCommendTime = new SqlParameter("@CommendTime", SqlDbType.DateTime); SqlParameter paramCommendStatus = new SqlParameter("@CommendStatus", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.CustomerSysNo != AppConst.IntNull) paramCustomerSysNo.Value = oParam.CustomerSysNo; else paramCustomerSysNo.Value = System.DBNull.Value; if (oParam.FriendName != AppConst.StringNull) paramFriendName.Value = oParam.FriendName; else paramFriendName.Value = System.DBNull.Value; if (oParam.CommendEmail != AppConst.StringNull) paramCommendEmail.Value = oParam.CommendEmail; else paramCommendEmail.Value = System.DBNull.Value; if (oParam.CommendTime != AppConst.DateTimeNull) paramCommendTime.Value = oParam.CommendTime; else paramCommendTime.Value = System.DBNull.Value; if (oParam.CommendStatus != AppConst.IntNull) paramCommendStatus.Value = oParam.CommendStatus; else paramCommendStatus.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramCustomerSysNo); cmd.Parameters.Add(paramFriendName); cmd.Parameters.Add(paramCommendEmail); cmd.Parameters.Add(paramCommendTime); cmd.Parameters.Add(paramCommendStatus); return SqlHelper.ExecuteNonQuery(cmd); }
public CustomerCommendInfo LoadCustomerCommend(string CommendEmail) { string sql = "select * from customer_commend where commendemail=" + Util.ToSqlString(CommendEmail); DataSet ds = SqlHelper.ExecuteDataSet(sql); if(!Util.HasMoreRow(ds)) return null; CustomerCommendInfo oInfo = new CustomerCommendInfo(); map(oInfo,ds.Tables[0].Rows[0]); return oInfo; }
private void map(CustomerCommendInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]); oParam.FriendName = Util.TrimNull(tempdr["FriendName"]); oParam.CommendEmail = Util.TrimNull(tempdr["CommendEmail"]); oParam.CommendTime = Util.TrimDateNull(tempdr["CommendTime"]); oParam.CommendStatus = Util.TrimIntNull(tempdr["CommendStatus"]); }
public int InsertCustomerCommend(CustomerCommendInfo oParam) { return new FreeShipFeeDac().Insert(oParam); }