protected void btnEdit_Click(object sender, EventArgs e)
{
if (!HelperUtility.hasPurviewOP("SalesContract_update"))
{
HelperUtility.showAlert("没有操作权限", "/BackManager/home.aspx");
}
int intAdminId = (int)ViewState["AdminId"];
int intId = (int)ViewState["id"];
int intPage = (int)ViewState["page"];
string strThisPageUrl = "edit.aspx?id=" + intId + "&page=" + intPage;
string strMsgError = "";
// 验证输入
string strCompanyName = tbCompanyName.Text.Trim();
if ("".Equals(strCompanyName))
{
strMsgError += "公司名不能为空！";
}
string strTimeSign = tbTimeSign.Value.ToString();
if ("".Equals(strTimeSign))
{
strMsgError += "入库单签发时间不能为空！";
}
if (!HelperUtility.isDateType(strTimeSign))
{
strMsgError += "入库单签发时间格式不正确！";
}
string strComment = tbComment.Text.Trim();
if (strComment.Length > 500)
{
strMsgError += "备注信息不能超过500个字数！";
}
if (!"".Equals(strMsgError))
{
HelperUtility.showAlert(strMsgError, strThisPageUrl);
return;
}
string strPhotoUrls = "";
// 验证完毕，提交数据
ModelSalesContract model = BllSalesContract.getById(intId);
if (strCompanyName.Contains("未知公司"))
{
model.id_company = 0;
}
else
{
model.id_company = BllSalesCompany.getIdByName(strCompanyName, intAdminId);
}
model.id_admin = intAdminId;
model.photo_urls = strPhotoUrls;
model.comment = strComment;
model.time_sign = Convert.ToDateTime(strTimeSign);
// 更新数据库记录
BllSalesContract.update(model);
// 跳转回列表页
Response.Redirect("/BackManager/sales_contract/list.aspx?page=" + intPage);
}
public static int update(ModelSalesContract model)
{
string strSQL = @"
UPDATE sales_contract
SET
id_company = @id_company,
id_admin = @id_admin,
time_sign = @time_sign,
time_create = @time_create,
photo_urls = @photo_urls,
comment = @comment,
is_deleted = @is_deleted
WHERE
id = @id
";
MySqlParameter[] aryParams = new MySqlParameter[8];
aryParams[0] = new MySqlParameter("@id_company", model.id_company);
aryParams[1] = new MySqlParameter("@id_admin", model.id_admin);
aryParams[2] = new MySqlParameter("@time_sign", model.time_sign);
aryParams[3] = new MySqlParameter("@time_create", model.time_create);
aryParams[4] = new MySqlParameter("@photo_urls", model.photo_urls);
aryParams[5] = new MySqlParameter("@comment", model.comment);
aryParams[6] = new MySqlParameter("@is_deleted", model.is_deleted);
aryParams[7] = new MySqlParameter("@id", model.id);
return(HelperMySql.ExecuteNonQuery(strSQL, aryParams));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int intAdminId = HelperUtility.hasPurviewPage("SalesContract_update");
ViewState["AdminId"] = intAdminId;
// 本页只能从list.aspx的编辑页转过来
// 因此要得到要修改的id值和页面的page值用于修改成功后返回
int intId = HelperUtility.getQueryInt("id");
ViewState["id"] = intId;
int intPage = HelperUtility.getQueryInt("page");
ViewState["page"] = intPage;
// 绑定销售公司名称的下拉列表数据
BllSalesCompany.bindRPT(rptName);
// 根据入库单id查询得到入库单model
ModelSalesContract model = BllSalesContract.getById(intId);
int intCompanyId = model.id_company;
if (intCompanyId > 0)
{
tbCompanyName.Text = (BllSalesCompany.getById(intCompanyId)).name;
}
else
{
tbCompanyName.Text = "未知公司";
}
tbTimeSign.Value = model.time_sign.ToString("yyyy-MM-dd");
tbComment.Text = model.comment;
}
}
// 导出入库单货品清单以便打印的Excel文件
public static string[] setExcel(int intContractId)
{
// 得到此入库单的信息
ModelSalesContract model = getById(intContractId);
string strCompanyName;
if (model.id_company > 0)
{
strCompanyName = BllSalesCompany.getById(model.id_company).name;
}
else
{
strCompanyName = "预入库";
}
string strYear = model.time_sign.Year.ToString();
string strMonth = model.time_sign.Month.ToString();
string strDay = model.time_sign.Day.ToString();
string strDateShow = " " + strYear + " " + strMonth + " " + strDay;
// 根据入库单ID得到此入库单下所有的入库货品记录，转成DataTable作为Excel文件的数据源
DataTable objDTAll = BllSalesGoods.getAll(intContractId);
DataSet objDS = HelperUtility.splitDataTable(objDTAll, 5);
string[] aryReturn = new string[objDS.Tables.Count];
DataTable objDT;
string strExcelTemplateFileName = "/Excel/Template/01入库单.xlsx";
string strExcelOutFileName;
for (int i = 0; i < objDS.Tables.Count; i++)
{
// 先对DataTable里的数据进行改造
objDT = objDS.Tables[i];
objDT.TableName = "DataTable";
WorkbookDesigner objDesigner = new WorkbookDesigner();
objDesigner.SetDataSource("SalesCompany", " " + strCompanyName);
objDesigner.SetDataSource("DateShow", strDateShow);
objDesigner.SetDataSource(objDT);
// 设置要输出的每个Excel文件的文件名
strExcelOutFileName = "/Excel/Export/入库单[" + strCompanyName +
model.time_sign.ToString("yyMMdd") + "]-" + (i + 1) + ".xlsx";
// 根据以上参数生成excel文件，并输出生成的excel文件路径
HelperExcel.ExportExcelByTemplate(objDesigner, strExcelTemplateFileName, strExcelOutFileName);
aryReturn[i] = strExcelOutFileName;
// 处理完成后把表名改成别的名字，DS中不能有重名的Table
objDT.TableName = "DataTable" + i;
}
return(aryReturn);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int intAdminId = HelperUtility.hasPurviewPage("SalesGoods_show");
ViewState["AdminId"] = intAdminId;
// 本页只能从list.aspx的编辑页转过来
// 因此要得到要显示哪个入库单的cid值和页面的cpage值用于返回
int intContractId = HelperUtility.getQueryInt("cid");
if (intContractId == 0)
{
HelperUtility.showAlert("", "/BackManager/login.aspx");
}
ViewState["ContractId"] = intContractId;
ViewState["ContractPage"] = HelperUtility.getQueryInt("cpage");
// 得到现在的页面值
int intCurrentPage = HelperUtility.getQueryInt("page");
if (intCurrentPage <= 0)
{
intCurrentPage = 1;
}
lblCurentPage.Text = intCurrentPage.ToString();
LoadDataPage();
// 设置其他控件值，以货币形式显示 2.5.ToString("C")
// 得到入库单的信息
ModelSalesContract model = BllSalesContract.getById(intContractId);
if (model.id_company > 0)
{
lblCompanyName.Text = "【" + BllSalesCompany.getById(model.id_company).name + "】";
}
else
{
lblCompanyName.Text = "【预入库】";
}
lblTimeCreate.Text = model.time_create.ToString("yyyy-MM-dd");
lblPriceTotal.Text = BllSalesGoods.getPriceTotal(intContractId).ToString("C");
hlBackContract.NavigateUrl = "../sales_contract/list.aspx?page=" + ViewState["ContractPage"];
hlAddNew.NavigateUrl = "add.aspx?cid=" + intContractId;
// 绑定所有入库单的下拉列表
BllSalesContract.bindDDL(ddlSalesContract);
}
}
public static int add(ModelSalesContract model)
{
string strSQL = @"
INSERT INTO sales_contract (
id_company,
id_admin,
time_sign,
time_create,
photo_urls,
comment,
is_deleted
) VALUES (
@id_company,
@id_admin,
@time_sign,
@time_create,
@photo_urls,
@comment,
@is_deleted
)";
MySqlParameter[] aryParams = new MySqlParameter[7];
aryParams[0] = new MySqlParameter("@id_company", model.id_company);
aryParams[1] = new MySqlParameter("@id_admin", model.id_admin);
aryParams[2] = new MySqlParameter("@time_sign", model.time_sign);
aryParams[3] = new MySqlParameter("@time_create", model.time_create);
aryParams[4] = new MySqlParameter("@photo_urls", model.photo_urls);
aryParams[5] = new MySqlParameter("@comment", model.comment);
aryParams[6] = new MySqlParameter("@is_deleted", model.is_deleted);
if (HelperMySql.ExecuteNonQuery(strSQL, aryParams) > 0)
{
strSQL = "SELECT MAX(id) FROM sales_contract";
object objReturn = HelperMySql.ExecuteScalar(strSQL);
return(objReturn == null ? 0 : Convert.ToInt32(objReturn));
}
else
{
return(0);
}
}
public static ModelSalesContract getById(int intId)
{
string strSQL = @"SELECT * FROM sales_contract WHERE id = @id";
MySqlParameter[] aryParams = new MySqlParameter[1];
aryParams[0] = new MySqlParameter("@id", intId);
DataTable objDT = HelperMySql.GetDataTable(strSQL, aryParams);
if (objDT == null || objDT.Rows.Count <= 0)
{
return(null);
}
ModelSalesContract model = new ModelSalesContract();
model.id = Convert.ToInt32(objDT.Rows[0]["id"]);
model.id_company = Convert.ToInt32(objDT.Rows[0]["id_company"]);
model.id_admin = Convert.ToInt32(objDT.Rows[0]["id_admin"]);
model.time_sign = Convert.ToDateTime(objDT.Rows[0]["time_sign"]);
model.time_create = Convert.ToDateTime(objDT.Rows[0]["time_create"]);
model.photo_urls = Convert.ToString(objDT.Rows[0]["photo_urls"]);
model.comment = Convert.ToString(objDT.Rows[0]["comment"]);
model.is_deleted = Convert.ToInt16(objDT.Rows[0]["is_deleted"]);
return(model);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!HelperUtility.hasPurviewOP("SalesContract_add"))
{
string strUrl = "/BackManager/home.aspx";
HelperUtility.showAlert("没有操作权限", strUrl);
}
string strMsgError = "";
string strCompanyName = tbCompanyName.Text.Trim();
if ("".Equals(strCompanyName))
{
strMsgError += "公司名不能为空！";
}
string strTimeSign = tbTimeSign.Value.ToString();
if ("".Equals(strTimeSign))
{
strMsgError += "入库单签发时间不能为空！";
}
if (!HelperUtility.isDateType(strTimeSign))
{
strMsgError += "入库单签发时间格式不正确！";
}
string strComment = tbComment.Text.Trim();
if (strComment.Length > 500)
{
strMsgError += "备注信息不能超过500个字数！";
}
if (!"".Equals(strMsgError))
{
HelperUtility.showAlert(strMsgError, "add.aspx");
return;
}
string strPhotoUrls = "";
// 验证完毕，提交数据
int intAdminId = (int)ViewState["AdminId"];
ModelSalesContract model = new ModelSalesContract();
if (strCompanyName.Contains("预入库"))
{
model.id_company = 0;
}
else
{
model.id_company = BllSalesCompany.getIdByName(strCompanyName, intAdminId);
}
model.id_admin = intAdminId;
model.time_sign = Convert.ToDateTime(strTimeSign);
model.photo_urls = strPhotoUrls;
model.comment = strComment;
int intId = BllSalesContract.add(model);
if (intId > 0)
{
string strUrl = "list.aspx";
HelperUtility.showAlert("添加成功！", strUrl);
}
else
{
string strUrl = "add.aspx";
HelperUtility.showAlert("添加失败，请联系管理员！", strUrl);
}
}
public static int update(ModelSalesContract model)
{
return(DalSalesContract.update(model));
}
public static int add(ModelSalesContract model)
{
return(DalSalesContract.add(model));
}
