/// <summary>
/// 查看会员电子转账(汇款)明细
/// </summary>
/// <returns></returns>
public static List <ECRemitDetailModel> GetECRemitDetail(ECRemitDetailModel detailmodel, DateTime EndTime)
{
//0001-1-1
string sql = "select * from ECRemitDetail where 1=1 ";
List <ECRemitDetailModel> list = new List <ECRemitDetailModel>();
if (detailmodel.RemitID != null)
{
sql = sql + " and RemitID ='" + detailmodel.RemitID + "'";
}
if (detailmodel.RemitDate != DateTime.Parse("0001-1-1"))
{
sql = sql + " and RemitDate between '" + detailmodel.RemitDate + "' and '" + EndTime + "'";
}
if (detailmodel.PayMentExpectNum != 0)
{
sql = sql + " and PaymentExpectNum =" + detailmodel.PayMentExpectNum;
}
SqlDataReader read = DBHelper.ExecuteReader(sql, CommandType.Text);
while (read.Read())
{
ECRemitDetailModel model = new ECRemitDetailModel();
model.ID = int.Parse(read["ID"].ToString());
model.IsAffirm = int.Parse(read["IsAffirm"].ToString());
model.GatheringID = read["GatheringID"].ToString();
model.RemitID = read["RemitID"].ToString();
model.PayMentExpectNum = int.Parse(read["PaymentExpectNum"].ToString());
model.PayMentDate = DateTime.Parse(read["PaymentDate"].ToString());
model.RemitMoney = double.Parse(read["RemitMoney"].ToString());
model.Currency = read["Currency"].ToString();
model.RemitterRemark = read["RemitterRemark"].ToString();
list.Add(model);
}
read.Close();
return(list);
}
/// <summary>
/// 汇款申报
/// </summary>
/// <returns></returns>
public static Boolean AddECRemitDetail(ECRemitDetailModel remitdetail)
{
return(ECRemitDetailDAL.AddECRemitDetail(remitdetail));
}
/// <summary>
/// 查看会员电子转账(汇款)明细
/// </summary>
/// <returns></returns>
public static List <ECRemitDetailModel> GetECRemitDetail(ECRemitDetailModel detail, DateTime EndTime)
{
return(ECRemitDetailDAL.GetECRemitDetail(detail, EndTime));
}
/// <summary>
/// 汇款申报
/// </summary>
/// <returns></returns>
public static Boolean AddECRemitDetail(ECRemitDetailModel remitemodel)
{
string str = string.Empty;
if (remitemodel.PayMentMethod == 0)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@RemitID", SqlDbType.VarChar, 40),
new SqlParameter("@GatheringID", SqlDbType.VarChar, 40),
new SqlParameter("@RemitMoney", SqlDbType.Money),
new SqlParameter("@Currency", SqlDbType.VarChar, 40),
new SqlParameter("@PaymentExpectNum", SqlDbType.Int),
new SqlParameter("@PaymentMethod", SqlDbType.Int),
new SqlParameter("@Confirmed", SqlDbType.Int),
new SqlParameter("@RemitDate", SqlDbType.DateTime),
new SqlParameter("@RemitterRemark", SqlDbType.VarChar, 200),
new SqlParameter("@AbouchementRemark", SqlDbType.VarChar, 200),
new SqlParameter("@error", SqlDbType.Int)
};
parameter[0].Value = remitemodel.ID;
parameter[1].Value = remitemodel.RemitID;
parameter[2].Value = remitemodel.GatheringID;
parameter[3].Value = remitemodel.RemitMoney;
parameter[4].Value = remitemodel.Currency;
parameter[5].Value = remitemodel.PayMentExpectNum;
parameter[6].Value = remitemodel.PayMentMethod;
parameter[7].Value = remitemodel.Confirmed;
parameter[8].Value = remitemodel.RemitDate;
parameter[9].Value = remitemodel.RemitterRemark;
parameter[10].Value = remitemodel.AbouchementRemark;
parameter[11].Direction = ParameterDirection.Output;
DBHelper.ExecuteNonQuery("AddECRemitDetail", parameter, CommandType.StoredProcedure);
str = parameter[11].Value.ToString();
}
if (remitemodel.PayMentMethod == 1)
{
SqlParameter[] parameter = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@RemitID", SqlDbType.VarChar, 40),
new SqlParameter("@GatheringID", SqlDbType.VarChar, 40),
new SqlParameter("@RemitMoney", SqlDbType.Money),
new SqlParameter("@Currency", SqlDbType.VarChar, 40),
new SqlParameter("@PaymentExpectNum", SqlDbType.Int),
new SqlParameter("@PaymentMethod", SqlDbType.Int),
new SqlParameter("@Confirmed", SqlDbType.Int),
new SqlParameter("@RemitDate", SqlDbType.DateTime),
new SqlParameter("@RemitterRemark", SqlDbType.VarChar, 200),
new SqlParameter("@AbouchementRemark", SqlDbType.VarChar, 200),
new SqlParameter("@RemitNumber", SqlDbType.VarChar, 50),
new SqlParameter("@RemitBank", SqlDbType.VarChar, 50),
new SqlParameter("@RemitCard", SqlDbType.VarChar, 50),
new SqlParameter("@AbouchementCard", SqlDbType.VarChar, 50),
new SqlParameter("@Remitter", SqlDbType.VarChar, 50),
new SqlParameter("@IdentityCard", SqlDbType.VarChar, 20),
new SqlParameter("@error", SqlDbType.Int)
};
parameter[0].Value = remitemodel.ID;
parameter[1].Value = remitemodel.RemitID;
parameter[2].Value = remitemodel.GatheringID;
parameter[3].Value = remitemodel.RemitMoney;
parameter[4].Value = remitemodel.Currency;
parameter[5].Value = remitemodel.PayMentExpectNum;
parameter[6].Value = remitemodel.PayMentMethod;
parameter[7].Value = remitemodel.Confirmed;
parameter[8].Value = remitemodel.RemitDate;
parameter[9].Value = remitemodel.RemitterRemark;
parameter[10].Value = remitemodel.AbouchementRemark;
parameter[11].Value = remitemodel.RemitNumber;
parameter[12].Value = remitemodel.RemitBank;
parameter[13].Value = remitemodel.RemitCard;
parameter[14].Value = remitemodel.AbouchementCard;
parameter[15].Value = remitemodel.Remitter;
parameter[16].Value = remitemodel.IdentityCard;
parameter[17].Direction = ParameterDirection.Output;
DBHelper.ExecuteNonQuery("AddECRemitDetail", parameter, CommandType.StoredProcedure);
str = parameter[17].Value.ToString();
}
return(int.Parse(str) > 0?false:true);
}
