📄 mainmodel_1.aspx.cs
字号:
using System;
using System.Reflection;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using com.unicafe.ui;
using com.unicafe.common;
using com.unicafe.security;
using com.ascs.plp.common;
using PLP_DRP.KC;
using Com.Ascs.Drp_KC;
using com.ascs.plp.cg;
using com.ascs.plp.publics;
namespace com.ascs.plp.publics
{
/// <summary>
/// MainModel_1 的摘要说明。
/// </summary>
public class MainModel_1 : com.unicafe.ui.UnicafePage //用特定页面的FormID代替此处的MainModel_1
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.HtmlControls.HtmlInputHidden Hidden1;
protected System.Web.UI.HtmlControls.HtmlInputHidden Hidden2;
protected System.Web.UI.HtmlControls.HtmlInputHidden Hidden3;
protected System.Web.UI.HtmlControls.HtmlInputHidden Hidden4;
protected System.Web.UI.HtmlControls.HtmlInputHidden Hidden5;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 页面加载事件处理函数
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// **************************************************************************
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!this.IsPostBack)
{
//this.VerifyPage();
//Label1.Text = this.CurrentEmployee.EmplName;
// 给绑定DataGrid控件的SQL语句进行赋值（注意，SQL语句赋值之后不要再修改）
ViewState["sql"] = "Select CKB.CKDM, CKB.CKMC, KWB.KWDM, KWB.KWMC, " +
"CPJBXX.CPDM, CPJBXX.CPMC, CPJBXX.SCCS, CPJBXX.CSBM, CPJBXX.CPXH, CPJBXX.CPGG, " +
"KCTZB.ZTBZ, XTCS.CSMC, KCTZB.CPSL, KCTZB.PDHSL, KCTZB.YKYY,KCTZB.RKRQ " +
"From CKB, KWB, CPJBXX, KCTZB, XTCS " +
"Where KCTZB.CKDM = CKB.CKDM and " +
"KCTZB.KWDM = KWB.KWDM and " +
"KCTZB.CPDM = CPJBXX.CPDM and " +
"KCTZB.ZTBZ = XTCS.CSDM and " +
"CKB.CKDM =KWB.CKDM " +
"Order by CKB.CKDM, KWB.KWDM";
string sql = ViewState["sql"].ToString();
//处理DataGrid控件（绑定DataGrid控件 -> 检查是否需要定位 -> 给导航文本赋值）
if(CommonService.HandleDataGrid(this, sql, DataGrid1, "Data", Label2, Label3, Label4) == false)
this.Response.Redirect("../publics/Error.aspx?errmsg=在处理数据时发生错误。");
}
else
{
//检查回发的请求操作是否是要进入上页或下页
if(CommonService.PageNavigate(this, DataGrid1, "Data", Label2, Label3, Label4) == false)
this.Response.Redirect("../publics/Error.aspx?errmsg=在处理数据时发生错误。");
}
}
/// *******************************************************************************
/// END
/// *******************************************************************************
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
/// **************************************************************************
/// BEIGIN
/// <summary>
/// 删除选中的项
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// **************************************************************************
private void LinkButton1_Click(object sender, System.EventArgs e)
{
string[] DataTypes = {"string","string","string","string","DateTime"};
string[] pk = {"Hidden1","Hidden3","Hidden4","Hidden2","Hidden5"};
//调用删除方法对选中的数据进行删除
CommonService.DelSelectRecord(this,DataGrid1,ViewState["sql"].ToString(),"Data","CheckBox1",DataTypes,pk,"Com.Ascs.Drp_KC.KCTZBMgr","DelKCTZB",1,"数据未能成功删除。");
//对页面导航文本进行重新赋值
CommonService.PageNavigatorText(DataGrid1,Label2, Label3, Label4);
}
/// *******************************************************************************
/// END
/// *******************************************************************************
private void LinkButton2_Click(object sender, System.EventArgs e)
{
// Com.Ascs.Drp_KC.KCTZB thisKCTZB = new KCTZB();
// Com.Ascs.Drp_KC.KCTZBMgr thisMgr = new KCTZBMgr();
// string ckdm,kwdm,cpdm,zlzk;
// DateTime rkrq;
// //生成错误页面的路径
// string path = "";
// for(int k=0; k<1; k++)
// {
// path = path + "../";
// }
//
// //打开数据库连接
// SqlConnection SqlCn = new SqlConnection (com.unicafe.common.Configuration.GetDBConnectionString());
// SqlCn.Open();
//
// try
// {
// //开始事务
// SqlTransaction SqlTrans = SqlCn.BeginTransaction();
// SqlCommand cmd = SqlCn.CreateCommand();
// cmd.Transaction = SqlTrans;
// //声明存储主关键字的变量
// //object[] obj = new object[DataTypes.Length];
//
// //对本页上DataGrid的所有行进行遍历
// for (int i=0; i<DataGrid1.Items.Count; i++)
// {
// //将当前行赋值给一个DataGridItem对象
// DataGridItem _item = DataGrid1.Items[i];
//
// //判断当前行上的CheckBox控件赋值给一个CheckBox对象
// CheckBox CheckFlag = (CheckBox)_item.FindControl("CheckBox1");
//
// //判断当前行上的复选框是否被选中，如果被选中则进行删除处理，否则不予处理
// if(CheckFlag.Checked == true)
// {
// //获取关键字的值
// ckdm = ((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl("Hidden1")).Value;
// kwdm = ((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl("Hidden2")).Value;
// cpdm = ((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl("Hidden3")).Value;
// zlzk = ((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl("Hidden4")).Value;
// rkrq = DateTime.Parse(((System.Web.UI.HtmlControls.HtmlInputHidden)_item.FindControl("Hidden5")).Value);
//
//
// //调用删除方法进行删除处理,如果没有成功删除则回滚事务并进入错误页面
// bool Flag = thisMgr.DelKCTZB(cmd,ckdm,cpdm,zlzk,kwdm,rkrq);
// //bool Flag = true;
// if(Flag == false)
// {
// SqlTrans.Rollback();
// path = path + "publics/Error.aspx?errmsg=" + "删除失败！";
// //定向到错误页面
// this.Response.Redirect(path);
// return;
// }
// }
// }
//
// //提交数据库修改
// SqlTrans.Commit();
//
// //重新绑定DataGrid控件
// if(CommonService.BindDataGrid(this,ViewState["sql"].ToString(),DataGrid1,"Data",true) == false)
// {
// path = "<script language=javascript>window.location='" + path + "publics/Error.aspx?errmsg=已经成功删除选定的数据，但在重新绑定数据时发生错误。';</script>";
//
// //定向到错误页面
// this.Response.Write(path);
// return;
// }
// return;
// }
// catch(Exception e1)
// {
// path = "<script language=javascript>window.location='" + path + "publics/Error.aspx?errmsg=" + "发生异常！" + "';</script>";
//
// //定向到错误页面
// this.Response.Write(path);
// LogService.Write(e1.Message);
// return;
// }
// finally
// {
// SqlCn.Close();
// }
}
/// *******************************************************************************
/// END
/// *******************************************************************************
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -