/// <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); }