protected void Page_Load(object sender, EventArgs e)
{
int id = 0;
if (int.TryParse(Request.QueryString["id"], out id))
{
ap = AlreadyPaidOperation.GetAlreadyPaidById(id);
}
FormDataBind();
}
public void CreateAlreadyPaid(AlreadyPaid ap)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@payment_method_id",ap.PaymentMethod.Id),
SqlUtilities.GenerateInputNVarcharParameter("@invoice", 50, ap.Invoice),
SqlUtilities.GenerateInputIntParameter("@carrier_id",ap.Carrier.Id),
SqlUtilities.GenerateInputIntParameter("@user_id", ap.User.Id),
SqlUtilities.GenerateInputIntParameter("@company_id", ap.CompanyId),
SqlUtilities.GenerateInputDateTimeParameter("@create_time", ap.CreateTime),
SqlUtilities.GenerateInputDateTimeParameter("@paid_time", ap.PaidTime),
SqlUtilities.GenerateInputNVarcharParameter("@encode", 50, ap.Encode),
SqlUtilities.GenerateInputParameter("@money", SqlDbType.Decimal, ap.Money),
SqlUtilities.GenerateInputNVarcharParameter("@remark", 500, ap.Remark),
SqlUtilities.GenerateInputDateTimeParameter("@start_time", ap.StartTime),
SqlUtilities.GenerateInputDateTimeParameter("@end_time", ap.EndTime)
};
string sql = "INSERT INTO already_paid(payment_method_id, invoice, carrier_id, user_id, company_id, create_time, paid_time, encode, money, remark, start_time, end_time) VALUES(@payment_method_id, @invoice, @carrier_id, @user_id, @company_id, @create_time, @paid_time, @encode, @money, @remark, @start_time, @end_time)";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public PaginationQueryResult<AlreadyPaid> GetAlreadyPaidByCompanyId(PaginationQueryCondition condition, int compId)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@company_id", compId)
};
PaginationQueryResult<AlreadyPaid> result = new PaginationQueryResult<AlreadyPaid>();
string sql = "SELECT TOP " + condition.PageSize + " id, payment_method_id, invoice, carrier_id, user_id, company_id, create_time, paid_time, encode, money, remark, start_time, end_time FROM already_paid WHERE is_delete = 0 AND company_id = @company_id";
if (condition.CurrentPage > 1)
{
sql += " AND id< (SELECT MIN(id) FROM (SELECT TOP " + condition.PageSize * (condition.CurrentPage - 1) + " id FROM already_paid WHERE is_delete = 0 AND company_id = @company_id ORDER BY id DESC) AS R )";
}
sql += " ORDER BY id DESC; SELECT COUNT(*) FROM already_paid WHERE is_delete = 0 AND company_id = @company_id ";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
AlreadyPaid ap = new AlreadyPaid();
ap.Id = dr.GetInt32(0);
ap.PaymentMethod=PaymentMethodOperation.GetPaymentMethodById(dr.GetInt32(1));
ap.Invoice = dr.GetString(2);
ap.Carrier = CarrierOperation.GetCarrierById(dr.GetInt32(3));
ap.User = UserOperation.GetUserById(dr.GetInt32(4));
ap.CompanyId = dr.GetInt32(5);
ap.CreateTime = dr.GetDateTime(6);
ap.PaidTime = dr.GetDateTime(7);
ap.Encode = dr.GetString(8);
ap.Money = dr.GetDecimal(9);
ap.Remark = dr.GetString(10);
ap.StartTime = dr.GetDateTime(11);
ap.EndTime = dr.GetDateTime(12);
result.Results.Add(ap);
}
dr.NextResult();
while (dr.Read())
{
result.TotalCount = dr.GetInt32(0);
}
}
return result;
}
public static void CreateAlreadyPaid(AlreadyPaid ap)
{
dal.CreateAlreadyPaid(ap);
}
public AlreadyPaid GetAlreadyPaidById(int id)
{
AlreadyPaid ap = null;
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputIntParameter("@id", id)
};
string sql = "SELECT id, payment_method_id, invoice, carrier_id, user_id, company_id, create_time, paid_time, encode, money, remark, start_time, end_time FROM already_paid WHERE id = @id";
using (SqlDataReader dr = SqlHelper.ExecuteReader(CommandType.Text, sql, param))
{
while (dr.Read())
{
ap = new AlreadyPaid();
ap.Id = dr.GetInt32(0);
ap.PaymentMethod = PaymentMethodOperation.GetPaymentMethodById(dr.GetInt32(1));
ap.Invoice = dr.GetString(2);
ap.Carrier = CarrierOperation.GetCarrierById(dr.GetInt32(3));
ap.User = UserOperation.GetUserById(dr.GetInt32(4));
ap.CompanyId = dr.GetInt32(5);
ap.CreateTime = dr.GetDateTime(6);
ap.PaidTime = dr.GetDateTime(7);
ap.Encode = dr.GetString(8);
ap.Money = dr.GetDecimal(9);
ap.Remark = dr.GetString(10);
ap.StartTime = dr.GetDateTime(11);
ap.EndTime = dr.GetDateTime(12);
}
}
return ap;
}
protected void btnConfirmPaid_Click(object sender, EventArgs e)
{
string sDate = Request.Form[txtStartDate.ID].Trim();
string eDate = Request.Form[txtEndDate.ID].Trim();
if (string.IsNullOrEmpty(sDate) || string.IsNullOrEmpty(eDate))
{
Response.Write("<script language='javascript' type='text/javascript'>alert('请指定具体的时间段！');</script>");
return;
}
DateTime startDate = new DateTime(1999, 1, 1);
DateTime endDate = new DateTime(1999, 1, 1);
if (!DateTime.TryParse(sDate, out startDate) || !DateTime.TryParse(eDate, out endDate))
{
Response.Write("<script language='javascript' type='text/javascript'>alert('请输入正确的时间格式，如：2008-8-8！');</script>");
return;
}
endDate = new DateTime(endDate.Year, endDate.Month, endDate.Day, 23, 59, 59);
if (ddlCarrier.SelectedItem.Value == "")
{
Response.Write("<script language='javascript' type='text/javascript'>alert('请指定承运商！');</script>");
return;
}
int carrierId = int.Parse(ddlCarrier.SelectedItem.Value);
confirmPaidResult = ShouldPayOperation.GetShouldPayByParameters(user.CompanyId, startDate, endDate, carrierId);
string strPaidTime = Request.Form[txtPaidTime.ID];
string invoice = Request.Form[txtInvoice.ID].Trim();
string remark = Request.Form[txtRemark.ID].Trim();
DateTime paidTime = new DateTime(1999, 1, 1);
if (string.IsNullOrEmpty(strPaidTime) || !DateTime.TryParse(strPaidTime, out paidTime))
{
lblMsg.Text = "付款日期不能为空，且只能为时间格式！";
return;
}
if (string.IsNullOrEmpty(invoice) || Validator.IsMatchLessThanChineseCharacter(invoice, INVOICE_LENGTH))
{
lblMsg.Text = "流水号不能为空，且长度不能超过" + INVOICE_LENGTH + "个字符！";
return;
}
if (!string.IsNullOrEmpty(remark) && Validator.IsMatchLessThanChineseCharacter(remark, REMARK_LENGTH))
{
lblMsg.Text = "备注长度不能超过" + REMARK_LENGTH + "个字符！";
return;
}
decimal totalMoney = 0;
Carrier carrier = null;
foreach (ShouldPay sp in confirmPaidResult)
{
ShouldPayOperation.UpdateShouldPayIsPaid(sp.Id);
carrier = sp.Carrier;
totalMoney += sp.OrderDetail.SelfTotalCosts;
}
AlreadyPaid ap = new AlreadyPaid();
ap.User = user;
ap.Remark = remark;
ap.PaymentMethod = PaymentMethodOperation.GetPaymentMethodById(int.Parse(ddlPaymentMethod.SelectedItem.Value));
ap.PaidTime = paidTime;
ap.Money = totalMoney;
ap.Invoice = invoice;
ap.Encode = StringHelper.GetEncodeNumber("FK");
ap.CreateTime = DateTime.Now;
ap.CompanyId = user.CompanyId;
ap.Carrier = carrier;
ap.Account = "";
ap.StartTime = startDate;
ap.EndTime = endDate;
AlreadyPaidOperation.CreateAlreadyPaid(ap);
Response.Write("<script language='javascript' type='text/javascript'>alert('操作成功！');location.href='AlreadyPaid.aspx';</script>");
}