/// <summary>
/// 抓取所有单据相关的部门 LIST
/// </summary>
public void Get_ddlDepart()
{
//给部门检索ddlxgry Dropdownlist 绑定数据源
BaseFun fun = new BaseFun();
string strSQL = @"
select distinct dept_name as dept_sname,dept_name
from(
SELECT b.dept_name as dept_name
FROM [dbo].[Baojia_sign_flow] A
JOIN HRM_EMP_MES B ON A.EMPID=B.workcode
AND a.receive_date is not null
) aa where 1=1 order by aa.dept_name " ;
DataTable departList = DbHelperSQL.Query(strSQL).Tables[0];
if (departList.Rows.Count > 0)
{
fun.initDropDownList(this.ddl_depart, departList, "dept_sname", "dept_name");
}
ddl_depart.Items.Insert(0, new ListItem("", ""));
//根据当前进入的人员所在部门，直接默认选择该部门
//根据人员工号，获取该人员所属部门名称
string getdepat_name = @" select distinct dept_name from HRM_EMP_MES
where workcode='" + Session["empid"].ToString() + "'";
if (DbHelperSQL.Query(getdepat_name).Tables[0].Rows.Count > 0)
{
this.ddl_depart.SelectedValue = DbHelperSQL.Query(getdepat_name).Tables[0].Rows[0][0].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
BaseFun fun = new BaseFun();
try
{
mainkey = Request.QueryString["KEY"].ToString(); //Session["PK_KEY_PIC"].ToString();
code = Request.QueryString["code"].ToString();
if (code == "0")
{
j = 20;
}
else if (code == "1")
{
j = 0;
}
else if (code == "2")
{
j = 21;
}
}
catch
{
mainkey = "100000630";
}
dt_m00203 = fun.getDtBySql("Select t.* from M00201 t where t.m00201_key=" + mainkey);
http_url = GetIndexUrl();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BaseFun fun = new BaseFun();
//初始化年份
//for (int i = 0; i < 5; i++)
//{
// txt_year.Items.Add(new ListItem((year - i).ToString(), (year - i).ToString()));
//}
string strsql = "select distinct year(dingdian_date)year from Baojia_agreement_flow order by year(dingdian_date) desc ";
DataSet dsYear = DbHelperSQL.Query(strsql);
fun.initDropDownList(dropYear, dsYear.Tables[0], "year", "year");
int year = Convert.ToInt16(DateTime.Now.ToString("yyyy"));
string mnth = DateTime.Now.Month.ToString();
DataSet ds = DbHelperSQL.Query("exec BaoJia_Dingdian_Query '" + dropYear.SelectedValue + "','0','','',''");
DataSet dt_mx = DbHelperSQL.Query("exec BaoJia_Dingdian_Query '" + dropYear.SelectedValue + "','0','0','',''");
DataTable dt = ds.Tables[0];
gv.DataSource = dt;
gv.DataBind();
Getsum(dt_mx.Tables[0]);
gvdetail.DataSource = dt_mx.Tables[0];
gvdetail.DataBind();
setGridLink();
bindChartYear(ds.Tables[1]);
LinkBtn.Style.Add("display", "none");
}
}
public void Get_updateuser_bydepart(string deptname)
{
if (deptname == "")
{
Get_ddl_update_user();
}
else
{
//给相关人员Dropdownlist 绑定数据源
BaseFun fun = new BaseFun();
string strSQL =
@"SELECT DISTINCT AA.empid empid,
AA.lastname lastname
FROM (
select A.EMPID AS empid,
B.lastname AS lastname,
B.dept_name AS dept_name from [dbo].[Baojia_sign_flow] a
JOIN HRM_EMP_MES B ON A.EMPID = B.workcode
AND a.receive_date is not null
) AA
WHERE AA.dept_name='" + deptname + "' ";
DataTable Updateusers = DbHelperSQL.Query(strSQL).Tables[0];
if (Updateusers.Rows.Count > 0)
{
fun.initDropDownList(this.ddl_update_user, Updateusers, "empid", "lastname");
}
ddl_update_user.Items.Insert(0, new ListItem("", ""));
}
}
protected void Page_Load(object sender, EventArgs e)
{
base.PageBase_Load(sender, e);
/*根据状态和数据获取主档的操作按钮*/
dt_rb = Fun.getdtByJson(Fun.getJson(json, "P5"));
req_url = BaseFun.getAllHyperLinks(RequestXml, "<URL>", "</URL>")[0].Value;
objid = BaseFun.getAllHyperLinks(RequestXml, "<KEY>", "</KEY>")[0].Value;
}
/// 项目大小下拉
public void ini_Project_Size()
{
string strSQL = @"select null as lookup_code,'' as lookup_desc union all SELECT [lookup_code] ,[lookup_desc] FROM [MES].[dbo].[Baojia_lookup_table] where lookup_type='project_size' and status='Y'";
DataTable dt = DbHelperSQL.Query(strSQL).Tables[0];
BaseFun fun = new BaseFun();
fun.initDropDownList(this.ddlProject_size, dt, "lookup_code", "lookup_desc");
}
/// 零件状态下拉
public void ini_HeTong_Status()
{
string strSQL = @" SELECT [lookup_code] ,[lookup_desc] FROM [MES].[dbo].[Baojia_lookup_table] where lookup_type='lj_status_q' and status='Y' order by lookup_code";
DataTable dt = DbHelperSQL.Query(strSQL).Tables[0];
BaseFun fun = new BaseFun();
fun.initDropDownList(this.ddlHetong_status, dt, "lookup_code", "lookup_desc");
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
menu_id = BaseFun.getAllHyperLinks(RequestXml, "<MENU_ID>", "</MENU_ID>")[0].Value;
dt_A002 = Fun.getDtBySql("Select * From A002 t Where T.MENU_ID = '" + menu_id + "'");
}
protected void Page_Load(object sender, EventArgs e)
{
RespXml = "0";
try
{
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
try
{
try
{
ConnectString = BaseFun.getAllHyperLinks(RequestXml, "<CONNSTR>", "</CONNSTR>")[0].Value;
execsql = BaseFun.getAllHyperLinks(RequestXml, "<EXECSQL>", "</EXECSQL>")[0].Value;
}
catch (Exception ex)
{
RespXml = "Error Xml";
}
if (execsql != string.Empty && execsql.Length > 10)
{
Udb.Oracle db = new Udb.Oracle(ConnectString, true);
db.BeginTransaction();
execsql = execsql.Trim();
int lidb = db.ExecuteNonQuery(execsql, CommandType.Text);
if (lidb < 0)
{
RespXml = db.ErrorMsg;
}
else
{
db.Commit();
}
}
}
catch (Exception ex)
{
RespXml = ex.Message;
}
}
catch (Exception ex)
{
RespXml = ex.Message;
return;
}
RespXml = RespXml.Replace("\n", ";").Replace("'", "\"").Replace(Environment.NewLine, "\"");
Response.Write(RespXml);
}
protected void Page_Load(object sender, EventArgs e)
{
base.PageBase_Load(sender, e);
/*根据状态和数据获取主档的操作按钮*/
dt_rb = Fun.getdtByJson(Fun.getJson(json, "P5"));
try
{
dt_print = Fun.getdtByJson(Fun.getJson(json, "P8"));
}
catch
{
}
req_url = BaseFun.getAllHyperLinks(RequestXml, "<URL>", "</URL>")[0].Value;
objid = BaseFun.getAllHyperLinks(RequestXml, "<KEY>", "</KEY>")[0].Value;
selectrowlist = BaseFun.getAllHyperLinks(RequestXml, "<ROWID>", "</ROWID>")[0].Value;
}
protected void Button1_Click(object sender, EventArgs e)
{
string uName = TxtUName.Text.Trim();
string uPass = TxtUPass.Text.Trim();
if (BaseFun.StrIsUName(uName) && BaseFun.StrIsUPass(uPass))
{
if (Session["bcode"] != null && Txtcheckcode.Text.Trim() == Session["bcode"].ToString())
{
int logStatus = new BllAdmUser().UserLoginIn(uName, uPass);
switch (logStatus)
{
case 1:
Response.Redirect("main.aspx");
break;
case -1:
LabErr.Text = "登录密码错误，请重新输入！";
break;
case -2:
LabErr.Text = "无此用户名，请检查是否输入错误！";
break;
case -3:
LabErr.Text = "您的帐号已被禁用，请联系管理员为您处理！";
break;
case -4:
LabErr.Text = "超过登录次数限制，请稍候再试！";
break;
}
}
else
{
LabErr.Text = "验证码有误！";
}
}
else
{
LabErr.Text = "用户名或密码格式错误！";
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
menu_id = BaseFun.getAllHyperLinks(RequestXml, "<MENU_ID>", "</MENU_ID>")[0].Value;
line_no = BaseFun.getAllHyperLinks(RequestXml, "<LINE_NO>", "</LINE_NO>")[0].Value;
string key = BaseFun.getAllHyperLinks(RequestXml, "<KEY>", "</KEY>")[0].Value;
dt_a002 = Fun.getDtBySql("Select t.* From a002 t Where t.menu_id='" + menu_id + "'");
dt_a00201 = Fun.getDtBySql("Select t.* From a00201 t Where t.menu_id='" + menu_id + "' And t.line_no='" + line_no + "'");
dt_a10001 = Fun.getDtBySql("select * from a10001 where table_id='" + dt_a00201.Rows[0]["TABLE_ID"].ToString() + "' Order By COL_X");
dt_temp = Fun.getDtBySql("select * from " + dt_a00201.Rows[0]["TABLE_ID"].ToString() + " t where t." + dt_a002.Rows[0]["MIAN_KEY"].ToString() + "='" + key + "' " + dt_a00201.Rows[0]["SORT_COL"].ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
BaseFun fun = new BaseFun();
//初始化年份
int year = Convert.ToInt16(DateTime.Now.ToString("yyyy"));
for (int i = 0; i < 5; i++)
{
dropYear.Items.Add(new ListItem((year - i).ToString(), (year - i).ToString()));
}
QueryA(); //
QueryB(); //
QueryC(); //
QueryD(); //
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
menu_id = BaseFun.getAllHyperLinks(RequestXml, "<MENU_ID>", "</MENU_ID>")[0].Value;
line_no = BaseFun.getAllHyperLinks(RequestXml, "<LINE_NO>", "</LINE_NO>")[0].Value;
col_line_no = BaseFun.getAllHyperLinks(RequestXml, "<COL_LINE_NO>", "</COL_LINE_NO>")[0].Value;
rowlist = BaseFun.getAllHyperLinks(RequestXml, "<ROWLIST>", "</ROWLIST>")[0].Value;
mainrowlist = BaseFun.getAllHyperLinks(RequestXml, "<MAINROWLIST>", "</MAINROWLIST>")[0].Value;
colid = BaseFun.getAllHyperLinks(RequestXml, "<COLID>", "</COLID>")[0].Value;
dt_A00201 = Fun.getDtBySql("select * from A00201_V01 t Where t.Menu_Id='" + menu_id + "' And t.Line_No=" + line_no);
dt_A10001 = Fun.getDtBySql("Select * From a10001 t Where t.table_id='" + dt_A00201.Rows[0]["TABLE_ID"].ToString() + "'");
}
protected void Page_Load(object sender, EventArgs e)
{
this.GridView1.PageSize = 200;
if (Session["empid"] == null || Session["job"] == null)
{
//Session["empid"] = "02088";
// 给Session["empid"] & Session["job"] 初始化
InitUser.GetLoginUserInfo(Page, Request.ServerVariables["LOGON_USER"]);
}
if (!IsPostBack)
{
Get_ddl_update_user(); //给相关人员Dropdownlist 绑定数据源
Get_ddlDepart(); //给相关部门Dropdownlist 绑定数据源
Get_updateuser_bydepart(this.ddl_depart.SelectedValue.ToString()); //根据部门号重新绑定人员
//年份
string sqlyear = "select distinct year(receive_date) year from Baojia_sign_flow where receive_date is not null";
BaseFun fun = new BaseFun();
fun.initDropDownList(ddlyear, DbHelperSQL.Query(sqlyear).Tables[0], "year", "year");
BaseFun.setDropSelectValue(ddlyear, DateTime.Now.Year.ToString(), "");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
reqtype = BaseFun.getAllHyperLinks(RequestXml, "<REQTYPE>", "</REQTYPE>")[0].Value;
if (reqtype == "HEQ_SAVE")
{
menu_id = BaseFun.getAllHyperLinks(RequestXml, "<MENU_ID>", "</MENU_ID>")[0].Value;
dt_a00201 = Fun.getDtBySql("select * from A00201_V01 t Where t.Menu_Id='" + menu_id + "'");
dt_a00210 = Fun.getDtBySql("Select * From A00210 t Where t.menu_id='" + menu_id + "'");
}
if (reqtype == "HEQ_NEW")
{
menu_id = BaseFun.getAllHyperLinks(RequestXml, "<MENU_ID>", "</MENU_ID>")[0].Value;
A00201_Key = BaseFun.getAllHyperLinks(RequestXml, "<A00201KEY>", "</A00201KEY>")[0].Value;
dt_a00201 = Fun.getDtBySql("select * from A00201_V01 t Where t.A00201_Key='" + A00201_Key + "'");
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Session["empid"]="02069";
if (Session["empid"] == null)
{ // 给Session["empid"]
InitUser.GetLoginUserInfo(Page, Request.ServerVariables["LOGON_USER"]);
}
if (!Page.IsPostBack)
{
BaseFun fun = new BaseFun();
DataTable dt = fun.getEmpInfo(Session["empid"].ToString());
this.txtXingMing.Value = dt.Rows[0]["empname"].ToString();
this.txtEmpId.Value = dt.Rows[0]["EMPLOYEEID"].ToString();
this.txtRiQi.Value = DateTime.Now.ToShortDateString();
this.txtBaoJia_no.Value = Request.QueryString["Baojia_no"];
this.txtTurns.Value = Request.QueryString["turns"];
//历史记录
ShowFile();
}
}
public void Get_ddl_update_user()
{
//给相关人员Dropdownlist 绑定数据源
BaseFun fun = new BaseFun();
string strSQL = @" SELECT DISTINCT AA.empid empid,
AA.lastname lastname
FROM (
select A.create_by_empid AS empid,
B.lastname AS lastname,
B.dept_name AS dept_name from [dbo].[Baojia_mst] a
JOIN HRM_EMP_MES B ON A.create_by_empid = B.workcode
where a.baojia_status='已报出'
) AA
WHERE 1 = 1 ";
DataTable Updateusers = DbHelperSQL.Query(strSQL).Tables[0];
if (Updateusers.Rows.Count > 0)
{
fun.initDropDownList(this.ddl_update_user, Updateusers, "empid", "lastname");
}
ddl_update_user.Items.Insert(0, new ListItem("", ""));
}
private void method_5(IPoint point, IFeature feature)
{
IPoint point2;
IPoint point3;
double num;
this.method_6(point, feature, out point2, out point3, out num);
IPoint point4 = point2;
IPoint point5 = point3;
object missing = Type.Missing;
IPointCollection pointCollection = new Polyline();
pointCollection.AddPoint(point4, ref missing, ref missing);
pointCollection.AddPoint(point5, ref missing, ref missing);
BaseFun baseFun = new BaseFun(pPipeCfg);
IElement lineElement = baseFun.GetLineElement((IPolyline)pointCollection);
((IGraphicsContainer)this.m_iApp.ActiveView).AddElement(lineElement, 0);
string sNoteText = string.Format("L = {0:f2}m", ((IPolyline)pointCollection).Length);
baseFun.NoteOrientationCenterText(this.m_iApp.ActiveView, (IPolyline)pointCollection, sNoteText);
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
menu_id = BaseFun.getAllHyperLinks(RequestXml, "<MENU_ID>", "</MENU_ID>")[0].Value;
dt_a00201 = Fun.getDtBySql("Select * From A00201_V01 t Where t.menu_id='" + menu_id + "' order by t.line_no");
pkg_name = dt_a00201.Rows[0]["PKG_NAME"].ToString();
if (pkg_name != "")
{
dt_btn = Fun.getDtBySql("select " + pkg_name + ".Checkbutton__('BTN_SAVE','','" + GlobeAtt.A007_KEY + "') as save," + pkg_name + ".Checkbutton__('BTN_DEL','','" + GlobeAtt.A007_KEY + "') as del from dual");
if (dt_btn.Rows.Count > 0)
{
f_save = dt_btn.Rows[0]["save"].ToString();
f_del = dt_btn.Rows[0]["del"].ToString();
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
//string str1 = null;
string strSql1 = null;
//string strSql2 = null;
DataTable ds = new DataTable();
//((Button)CrystalReportViewer1.Controls[1]).Click
try
{
rd1.Load(Server.MapPath("rptSerialTrain.rpt"));
//strSql1 = "select * from Employees where EmployeeID<10";
//strSql2 = "select * from Orders where OrderID<10270"; // where uidN='03557115-2526'";
//ds = com.TFMI.DAL.TFMIDbHelper.selectDataSetBindReport(strSql1, "Employees", strSql2, "Orders", "Default.aspx");
strSql1 = "select * from bl_v_rpt_serial_transaction t Where t.transaction_id='3633361'";
BaseFun fun = new BaseFun();
ds = fun.getDtBySql(strSql1);
rd1.SetDataSource(ds);
//"http://localhost/ShowErpForm/Report/Code39handler.ashx?Code=" & {BL_V_RPT_SERIAL_TRANSACTION.SERIAL_NO}
//rd1.SetParameterValue("P1", "ABC-X78901234");
CrystalReportViewer1.ReportSource = rd1;
}
catch (LoadSaveReportException ex)
{
Response.Write(ex.Message); // 報表載入失敗
}
catch (PrintException ex)
{
Response.Write(ex.Message); // 報表載入失敗
}
catch (Exception ex)
{
Response.Write(ex.Message); // 報表載入失敗
}
}
public void Get_ddl_update_user()
{
//给相关人员Dropdownlist 绑定数据源
BaseFun fun = new BaseFun();
string strSQL = @" SELECT DISTINCT AA.empid empid,
AA.lastname lastname
FROM (
select A.empid AS empid,
B.lastname AS lastname,
B.dept_name AS dept_name from [dbo].[Baojia_sign_flow] a
JOIN HRM_EMP_MES B ON A.empid = B.workcode
where a.receive_date is not null
) AA
WHERE 1 = 1 ";
DataTable Updateusers = DbHelperSQL.Query(strSQL).Tables[0];
if (Updateusers.Rows.Count > 0)
{
fun.initDropDownList(this.ddl_update_user, Updateusers, "empid", "lastname");
}
ddl_update_user.Items.Insert(0, new ListItem("", ""));
//进入界面直接默认显示该人员
// this.ddl_update_user.SelectedValue = Session["empid"].ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
base.PageBase_Load(sender, e);
try
{
IFSHOW = BaseFun.getAllHyperLinks(RequestXml, "<IFSHOW>", "</IFSHOW>")[0].Value;
ROWID = BaseFun.getAllHyperLinks(RequestXml, "<ROWID>", "</ROWID>")[0].Value;
ROWID = ROWID.Replace(a00201_key + "_", "");
}
catch
{
IFSHOW = "0";
ROWID = "0";
}
try
{
main_key_value = BaseFun.getAllHyperLinks(RequestXml, "<KEY>", "</KEY>")[0].Value;
if (IFSHOW == "1")
{
rowlist = main_key_value;
main_key_value = "";
}
option = BaseFun.getAllHyperLinks(RequestXml, "<OPTION>", "</OPTION>")[0].Value;
/*新增*/
string data_sql = "";
if (option == "I")
{
data_sql = showdatasql + " AND 1=2";
}
else
{
string nullhead = "0";
try
{
nullhead = dt_a00201.Rows[0]["nullhead"].ToString();
}
catch
{
nullhead = "0";
}
if (nullhead != "1")
{
if (dt_a00201.Rows[0]["MAIN_KEY"].ToString() != "")
{
data_sql = showdatasql + " AND " + dt_a00201.Rows[0]["MAIN_KEY"].ToString() + "='" + main_key_value + "'";
}
else
{
data_sql = showdatasql + " AND " + dt_a00201.Rows[0]["TABLE_KEY"].ToString() + "='" + main_key_value + "'";
}
}
else
{
data_sql = showdatasql;
}
//判断用户有没有菜单的权限
string show_condition = dt_a00201.Rows[0]["SHOW_CONDITION"].ToString();
if (show_condition == null)
{
show_condition = "";
}
if (show_condition.Length > 1)
{
show_condition = show_condition.Replace("[MAIN_KEY]", main_key_value);
if (show_condition.Trim().ToLower().IndexOf("and") != 0)
{
show_condition = " AND " + show_condition;
}
data_sql = data_sql + show_condition;
}
}
if (IFSHOW == "1")
{
data_sql = data_sql + " AND 1=2";
}
/*把查询的写日志记录到A00601中*/
if (GlobeAtt.BS_LOG_SELECTSQL == "1")
{
string log_sql = "pkg_a.saveQuerySql('" + GlobeAtt.A007_KEY + "', '" + a00201_key + "' , '" + data_sql.Replace("'", "''") + "','" + main_key_value + "' ) ";
// Fun.execSqlOnly(log_sql);
try
{
Fun.saveQuerySql(a00201_key, data_sql, main_key_value, option);
}
catch
{
}
}
Session["QUERY" + a00201_key] = data_sql;
dt_data = Fun.getDtBySql(data_sql);
if (dt_data.Rows.Count == 0)
{
DataRow dr = dt_data.NewRow();
dt_data.Rows.Add(dr);
}
}
catch (Exception ex)
{
Response.Write("ERROR URL");
}
}
private void button1_Click(object sender, System.EventArgs e)
{
DataTable tbsl = (DataTable)this.myDataGrid1.DataSource;
if (tbsl.Rows.Count > 0)
{
MessageBox.Show("当有数量误差时不能作账务调整，必须先解决数量误差，请和管理员联系!"); return;
}
DataTable tbje = (DataTable)this.myDataGrid2.DataSource;
if (tbje.Rows.Count == 0)
{
MessageBox.Show("没有需要作调整的数据"); return;
}
if (MessageBox.Show("您确定要将金额误差数据作账务处理行吗 ？", "询问窗", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
decimal sumlsje = 0;
decimal sumpfje = 0;
for (int i = 0; i <= tbje.Rows.Count - 1; i++)
{
sumlsje = sumlsje + Convert.ToDecimal(tbje.Rows[i]["零售金额差值"]);
sumpfje = sumpfje + Convert.ToDecimal(tbje.Rows[i]["批发金额差值"]);
}
if (sumlsje >= 100 || sumpfje >= 100)
{
MessageBox.Show("调整金额太大了，系统数据可能存在问题！请和管理员联系");
return;
}
long djh = 0; //单据号
long djid = 0; //主表ID
int err_code = 0; //错误号
string err_text = ""; //借误文本
string sDate = XcDate.ServerDateTime.ToString(); //登记时间
this.button1.Enabled = false;
OleDbTransaction myTrans;
myTrans = DB.sConnect.BeginTransaction();
try
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.Connection = DB.sConnect;
cmd.Transaction = myTrans;
//产生单据号
djh = BaseFun.SeekNewDjh(_ywlx.Trim(), _deptID, cmd);
//保存单据表头
YK_DJ_DJMX.SaveDJ(0,
djh,
_deptID,
_ywlx.Trim(),
0,
Convert.ToInt32(_deptID),
0,
Convert.ToDateTime(sDate).ToShortDateString(),
_employeeID,
Convert.ToDateTime(sDate).ToShortDateString(),
Convert.ToDateTime(sDate).ToLongTimeString(),
"",
"",
"",
"",
0,
0,
0,
sumpfje,
sumlsje,
out djid, out err_code, out err_text, cmd);
if (err_code != 0)
{
throw new System.Exception(err_text);
}
//保存单据明细
DataTable tb = (DataTable)this.myDataGrid2.DataSource;
if (tb.Rows.Count == 0)
{
MessageBox.Show("没有可保存的记录"); return;
}
;
cmd.Parameters.Clear();
for (int i = 0; i <= tb.Rows.Count - 1; i++)
{
YK_DJ_DJMX.SaveDJMX(0,
djid,
Convert.ToInt32(tb.Rows[i]["cjid"]),
0,
"",
"",
0,
0,
0,
Convert.ToString(tb.Rows[i]["单位"]),
BaseFun.SeekYpdw(Convert.ToString(tb.Rows[i]["单位"])),
Convert.ToInt32(tb.Rows[i]["dwbl"]),
0,
0,
0,
0,
Convert.ToDecimal(tb.Rows[i]["批发金额差值"]) * (-1),
Convert.ToDecimal(tb.Rows[i]["零售金额差值"]) * (-1),
djh,
_deptID,
_ywlx.Trim(),
"",
"",
out err_code, out err_text, cmd);
cmd.Parameters.Clear();
if (err_code != 0)
{
throw new System.Exception(err_text);
}
}
//审核单据
YK_DJ_DJMX.Shdj(djh,
_deptID,
_employeeID,
sDate,
_ywlx.Trim(),
cmd);
//提交事务
myTrans.Commit();
DB.Colse();
MessageBox.Show(err_text);
}
catch (System.Exception err)
{
myTrans.Rollback();
DB.Colse();
this.button1.Enabled = true;
MessageBox.Show(err.Message + err.Source);
}
}
public void PageBase_Load(object sender, System.EventArgs e)
{
if (GlobeAtt.A007_KEY == "")
{
Response.Write("showlogin();");
return;
}
try
{
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
a00201_key = BaseFun.getAllHyperLinks(RequestXml, "<A00201KEY>", "</A00201KEY>")[0].Value;
try
{
RequestURL = BaseFun.getAllHyperLinks(RequestXml, "<URL>", "</URL>")[0].Value;
}
catch
{
RequestURL = "";
}
}
catch (Exception ex)
{
a00201_key = "-1";
return;
}
// a00201_key = Request.QueryString["A00201KEY"] == null ? "-1" : Request.QueryString["A00201KEY"].ToString();
if (a00201_key == "-1")
{
return;
}
try
{
json = Session["JSON_" + a00201_key].ToString();
}
catch
{
json = "";
}
if (GlobeAtt.SYS_MODE == "K")
{
json = "";
}
if (json == "")
{
Hashtable ht = new Hashtable();
dt_a013010101 = Fun.getA013010101(a00201_key);
dt_a00201 = Fun.getDtBySql("Select t.* from A00201_V01 t where a00201_key = '" + a00201_key + "' order by line_no ");
//列属性
ht.Add("P1", Fun.DataTable2Json(dt_a013010101));
//菜单属性
ht.Add("P2", Fun.DataTable2Json(dt_a00201));
//数据检测属性
if (dt_a00201.Rows[0]["IF_MAIN"].ToString() == "1")
{
ht.Add("P3", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00210_V01 t where menu_id ='" + dt_a00201.Rows[0]["MENU_ID"].ToString() + "' and rb_type='C'")));
ht.Add("P4", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00210_V01 t where menu_id ='" + dt_a00201.Rows[0]["MENU_ID"].ToString() + "' and rb_type='U'")));
ht.Add("P9", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00201_V01 t where menu_id ='" + dt_a00201.Rows[0]["MENU_ID"].ToString() + "' order by line_no")));
}
//右键属性
ht.Add("P5", Fun.DataTable2Json(Fun.getDtBySql("select t.* from a00201_v02 t where a00201_key ='" + a00201_key + "' order by sort_by")));
//查询数据的SQL
showdatasql = Fun.getShowDataSql(a00201_key);
ht.Add("P6", showdatasql);
//查询数据数量的SQL
getShowDataCountSql = Fun.getShowDataCountSql(a00201_key);
ht.Add("P7", getShowDataCountSql);
//打印列表
if (dt_a00201.Rows[0]["if_main"].ToString() == "1")
{
ht.Add("P8", Fun.DataTable2Json(Fun.getDtBySql("select t.* from A00205 t where menu_id ='" + dt_a00201.Rows[0]["menu_id"].ToString() + "' order by sort_by")));
}
else
{
ht.Add("P8", "");
}
string form_init = dt_a00201.Rows[0]["FORM_INIT"].ToString();
ht.Add("P10", form_init);
string jsonText = JsonConvert.SerializeObject(ht);
Session["JSON_" + a00201_key] = jsonText;
json = jsonText;
}
else
{
dt_a013010101 = Fun.getdtByJson(Fun.getJson(json, "P1"));
dt_a00201 = Fun.getdtByJson(Fun.getJson(json, "P2"));
showdatasql = Fun.getJson(json, "P6");
getShowDataCountSql = Fun.getJson(json, "P7");
}
try
{
QUERYID = BaseFun.getAllHyperLinks(RequestXml, "<QUERYID>", "</QUERYID>")[0].Value;
}
catch
{
QUERYID = "";
}
string condition = "";
if (QUERYID != "")
{
condition = Fun.getQueryCondition(dt_a00201, QUERYID);
int pos = condition.IndexOf("ORDER BY");
string str_order = "";
if (pos > 0)
{
str_order = condition.Substring(pos);
condition = condition.Substring(0, pos - 1);
}
showdatasql = showdatasql + condition + " " + str_order;
getShowDataCountSql = getShowDataCountSql + condition;
}
string url = "";
try
{
url = BaseFun.getAllHyperLinks(RequestXml, "<URL>", "</URL>")[0].Value;
}
catch
{
url = "";
}
if (url.IndexOf("?") > 0)
{
int pos = url.IndexOf("?");
url = url.Substring(pos + 1);
string[] data_ = url.Split('&');
for (int i = 0; i < data_.Length; i++)
{
string[] data1_ = data_[i].Split('=');
showdatasql = showdatasql.Replace("[REQUEST_" + data1_[0] + "]", data1_[1]);
getShowDataCountSql = getShowDataCountSql.Replace("[REQUEST_" + data1_[0] + "]", data1_[1]);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string u_select_sql = "";
PageRow = int.Parse(GlobeAtt.DetailRowS);
MaxRow = int.Parse(GlobeAtt.QueryList_MaxRow);
string if_main = dt_a00201.Rows[0]["if_main"].ToString();
string sort_col = dt_a00201.Rows[0]["sort_col"].ToString();
Boolean if_select = false;
if (sort_col == null)
{
sort_col = "";
}
ifinsertrow = Request.QueryString["IFINSERT"] == null ? "V" : Request.QueryString["IFINSERT"].ToString();
/*新增*/
main_key_value = BaseFun.getAllHyperLinks(RequestXml, "<KEY>", "</KEY>")[0].Value;
option = BaseFun.getAllHyperLinks(RequestXml, "<OPTION>", "</OPTION>")[0].Value;
//调整dt_a013010101 的数据
if (dt_a013010101.Rows.Count > 0)
{
string a016_a016_enable = dt_a013010101.Rows[0]["a016_enable"].ToString();
DataTable dt = dt_a013010101.Clone();
dt.Clear();
//格式化列
for (int i = 0; i < dt_a013010101.Rows.Count; i++)
{
a016_a016_enable = dt_a013010101.Rows[i]["a016_enable"].ToString();
if (a016_a016_enable == "0" || a016_a016_enable == "1")
{
string A016_ENABLE = dt_a013010101.Rows[i]["A016_ENABLE"].ToString();
if (A016_ENABLE == "0")
{
dt_a013010101.Rows[i]["COL_ENABLE"] = "0";
}
string A016_VISIBLE = dt_a013010101.Rows[i]["A016_VISIBLE"].ToString();
if (A016_VISIBLE == "0")
{
dt_a013010101.Rows[i]["COL_VISIBLE"] = "0";
}
string A016_NECESSARY = dt_a013010101.Rows[i]["A016_NECESSARY"].ToString();
if (A016_NECESSARY == "1")
{
dt_a013010101.Rows[i]["COL_NECESSARY"] = "1";
}
string a016_col_x = dt_a013010101.Rows[i]["a016_col_x"].ToString();
if (a016_col_x != null && a016_col_x != "")
{
dt_a013010101.Rows[i]["COL_X"] = decimal.Parse(a016_col_x);
}
string a016_bs_width = dt_a013010101.Rows[i]["a016_bs_width"].ToString();
string bs_width = dt_a013010101.Rows[i]["bs_width"].ToString();
if (a016_bs_width != null && a016_bs_width != "" && a016_bs_width != bs_width)
{
dt_a013010101.Rows[i]["bs_width"] = decimal.Parse(a016_bs_width);
string bs_edit_width = dt_a013010101.Rows[i]["BS_EDIT_WIDTH"].ToString();
dt_a013010101.Rows[i]["BS_EDIT_WIDTH"] = decimal.Parse(bs_edit_width) + (decimal.Parse(a016_bs_width) - decimal.Parse(bs_width));
string col_width = dt_a013010101.Rows[i]["col_width"].ToString();
dt_a013010101.Rows[i]["col_width"] = decimal.Parse(col_width) + (decimal.Parse(a016_bs_width) - decimal.Parse(bs_width));
}
}
string col01 = dt_a013010101.Rows[i]["col01"].ToString().ToLower();
if (col01 == "1")
{
if_select = true;
string COLUMN_ID = dt_a013010101.Rows[i]["COLUMN_ID"].ToString();
string line_no = dt_a013010101.Rows[i]["LINE_NO"].ToString();
string select_sql_ = dt_a013010101.Rows[i]["SELECT_SQL"].ToString();
select_sql_ = select_sql_.Replace("[A007_KEY]", GlobeAtt.A007_KEY);
select_sql_ = select_sql_.Replace("[A30001_KEY]", GlobeAtt.A30001_KEY);
select_sql_ = select_sql_.Replace("[USER_ID]", GlobeAtt.A007_KEY);
select_sql_ = select_sql_.Replace("[MAIN_KEY]", main_key_value);
dt_temp = Fun.getDtBySql(select_sql_);
//sql
string BS_HTML_ = dt_a013010101.Rows[i]["BS_HTML"].ToString();
string col10 = dt_a013010101.Rows[i]["col10"].ToString();
string col_X = dt_a013010101.Rows[i]["COL_X"].ToString();
for (int j = 0; j < dt_temp.Rows.Count; j++)
{
string id = dt_temp.Rows[j][0].ToString();
string name = dt_temp.Rows[j][1].ToString();
DataRow dr = dt_a013010101.NewRow();
dr = dt_a013010101.Rows[i];
dr["COLUMN_ID"] = COLUMN_ID + id;
dr["COL_TEXT"] = name;
dr["COL_X"] = double.Parse(col_X) + 0.0001 * j;
dr["A10001_KEY"] = int.Parse(line_no) * 1000 + j;
string BS_HTML = BS_HTML_.Replace("[" + COLUMN_ID + "]", "[" + COLUMN_ID + id + "]");
BS_HTML = BS_HTML.Replace("[" + dt_temp.Columns[0].ToString().ToUpper() + "]", id);
dr["BS_HTML"] = BS_HTML;
dt.ImportRow(dr);
//替换列名称
u_select_sql = u_select_sql + col10.Replace("[" + dt_temp.Columns[0].ToString().ToUpper() + "]", id) + " as " + COLUMN_ID + id + ",";
}
}
else
{
dt.ImportRow(dt_a013010101.Rows[i]);
}
}
dt_a013010101 = dt;
DataRow[] rows = dt_a013010101.Select("", "COL_X asc");
DataTable t = dt_a013010101.Clone();
t.Clear();
foreach (DataRow row in rows)
{
t.ImportRow(row);
}
dt_a013010101 = t;
}
if (option == "Q")
{
PageRow = int.Parse(GlobeAtt.QueryList_PageRow);
string PageRow_ = dt_a00201.Rows[0]["pagerows"].ToString();
if (PageRow_ != null && PageRow_ != "")
{
PageRow = int.Parse(PageRow_);
}
}
else
{
string PageRow_ = dt_a00201.Rows[0]["pagerows"].ToString();
if (PageRow_ != null && PageRow_ != "")
{
PageRow = int.Parse(PageRow_);
}
}
try
{
PageNum = int.Parse(BaseFun.getAllHyperLinks(RequestXml, "<PageNum>", "</PageNum>")[0].Value);
}
catch
{
PageNum = 1;
}
string data_sql = "";
string con_sql = "";
if (option != "Q")
{
if (option == "I")
{
con_sql = con_sql + " AND 1=2";
}
else
{
if (dt_a00201.Rows[0]["if_main"].ToString() != "1")
{
if (dt_a00201.Rows[0]["MAIN_KEY"].ToString() != "")
{
con_sql = con_sql + " AND " + dt_a00201.Rows[0]["MAIN_KEY"].ToString() + "='" + main_key_value + "'";
}
else
{
con_sql = con_sql + " AND " + dt_a00201.Rows[0]["TABLE_KEY"].ToString() + "='" + main_key_value + "'";
}
}
}
}
else
{
// showdatasql = replace_getShowDataSql(dt_a013010101, showdatasql, u_select_sql);
if (PageNum <= 0)
{
string RETRIEVE = dt_a00201.Rows[0]["RETRIEVE"].ToString();
if (RETRIEVE != "1")
{
con_sql = con_sql + " AND 1=2";
}
}
string A002ID = BaseFun.getAllHyperLinks(RequestXml, "<A002ID>", "</A002ID>")[0].Value;
if (a00201_key != A002ID)
{
option = "V";
con_sql = con_sql + " AND " + dt_a00201.Rows[0]["MAIN_KEY"].ToString() + "='" + main_key_value + "'";
}
//if (RequestURL.ToUpper().IndexOf("QUERYDATA.ASPX") > 0 && main_key_value != "")
//{
// con_sql = con_sql + " AND " + dt_a00201.Rows[0]["TABLE_KEY"].ToString() + "='" + main_key_value + "'";
//}
}
if (option == "Q")
{
con_sql = con_sql + " AND ROWNUM <=" + dt_a00201.Rows[0]["MAXROWS"].ToString();
}
int pos = showdatasql.IndexOf("ORDER BY");
string str_order = "";
if (pos > 0)
{
str_order = " " + showdatasql.Substring(pos);
showdatasql = showdatasql.Substring(0, pos - 1);
}
else
{
str_order = " " + sort_col;
}
data_sql = showdatasql + con_sql + str_order;
getShowDataCountSql = getShowDataCountSql + con_sql;
data_sql = data_sql.Replace("[MAIN_KEY]", main_key_value);
getShowDataCountSql = getShowDataCountSql.Replace("[MAIN_KEY]", main_key_value);
/*把查询的写日志记录到A00601中*/
if (GlobeAtt.BS_LOG_SELECTSQL == "1")
{
string log_sql = "pkg_a.saveQuerySql('" + GlobeAtt.A007_KEY + "', '" + a00201_key + "' , '" + data_sql.Replace("'", "''") + "','" + main_key_value + "' ) ";
try
{
Fun.saveQuerySql(a00201_key, data_sql, main_key_value, option);
}
catch (Exception ex)
{
log_sql = ex.Message;
}
}
if (option != "Q")
{
if (if_select)
{
data_sql = "Select a.* , " + u_select_sql + " rownum as rn from (" + data_sql + ") a where rownum <= " + (PageNum * PageRow).ToString();
}
else
{
data_sql = "Select a.* , rownum as rn from (" + data_sql + ") a where rownum <= " + (PageNum * PageRow).ToString();
}
}
else
{
data_sql = "Select a.* , rownum as rn from (" + data_sql + ") a where rownum <= " + (PageNum * PageRow).ToString();
}
data_sql = "Select b.* from (" + data_sql + ") b where rn > " + ((PageNum - 1) * PageRow).ToString();
Session["QUERY" + a00201_key] = data_sql;
DateTime ld = DateTime.Now;
dt_data = Fun.getDtBySql(data_sql);
double le = (DateTime.Now - ld).TotalSeconds;
string sql_ = "Select pkg_show.geta00204('" + a00201_key + "','" + main_key_value + "','" + GlobeAtt.A007_KEY + "','0','" + option + "','" + status + "') as c from dual ";
if (option == "Q")
{
sql_ = "Select pkg_show.geta00204('" + a00201_key + "','[LIST]','" + GlobeAtt.A007_KEY + "','1','Q') as c from dual ";
}
dt_a00204 = Fun.getDtBySql(sql_);
double GRID_SECONDS = 5;
try
{
GRID_SECONDS = double.Parse(GlobeAtt.GetValue("GRID_SECONDS"));
}
catch
{
GRID_SECONDS = 5;
}
if (le < GRID_SECONDS)
{
dt_temp = Fun.getDtBySql(getShowDataCountSql);
try
{
rowscount = int.Parse(dt_temp.Rows[0][0].ToString());
}
catch
{
rowscount = 0;
}
}
else
{
if (dt_data.Rows.Count < PageRow)
{
rowscount = dt_data.Rows.Count;
}
else
{
rowscount = int.Parse(dt_a00201.Rows[0]["MAXROWS"].ToString());
}
}
pagecount = rowscount / PageRow;
if (rowscount % PageRow > 0)
{
pagecount = pagecount + 1;
}
}
catch (Exception ex)
{
Response.Write("ERROR URL:" + ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//
string showreport = Request.QueryString["showreport"] == null ? "0" : Request.QueryString["showreport"].ToString();
//rd = new ReportDocument();
if (showreport == "1")
{
try
{
this.Button1.Visible = false;
string PARM = Request.QueryString["PARM"] == null ? "0" : Request.QueryString["PARM"].ToString();
if (PARM != "0")
{
string data_index = GlobeAtt.DATA_INDEX;
string strdata = data_index + DES.DESDecrypt(PARM, DES.Key);
strdata = strdata.Trim();
report_file = BaseFun.getStrByIndex(strdata, data_index + "REPORT_FILE|", data_index);
report_sql = BaseFun.getStrByIndex(strdata, data_index + "REPORT_SQL|", data_index);
report_parm = BaseFun.getStrByIndex(strdata, data_index + "REPORT_PARM|", data_index);
}
else
{
report_file = Session["REPORT_FILE"].ToString();
report_sql = Session["REPORT_SQL"].ToString();
report_parm = Session["REPORT_PARM"].ToString();
}
// Response.Write(report_sql);
ReportDocument rd = new ReportDocument();
string file_ = Server.MapPath("../Report/" + report_file);
try
{
rd.Load(file_);
// cs.ReportDocument.Load(rd.FileName);
PageMargins pm = new PageMargins();
rd.PrintOptions.ApplyPageMargins(pm);
}
catch (Exception ex)
{
Response.Write(report_file + ex.Message);
return;
}
if (report_sql.Length > 10)
{
Oracle db = new Oracle();
DataTable dt_report = new DataTable();
db.ExcuteDataTable(dt_report, report_sql, CommandType.Text);
rd.SetDataSource(dt_report);
CrystalReportViewer1.ReportSource = rd;
CrystalReportViewer1.DataBind();
}
else
{
Oracle db = new Oracle();
ConnectionInfo ConnectionInfo1 = new ConnectionInfo();
ConnectionInfo1 = rd.Database.Tables[0].LogOnInfo.ConnectionInfo;
rd.SetDatabaseLogon(db.user_id, db.password);
ConnectionInfo1.DatabaseName = "";
ConnectionInfo1.UserID = db.user_id;
ConnectionInfo1.Password = db.password;
ConnectionInfo1.ServerName = db.data_source;
SetDBLogonForReport(ConnectionInfo1, rd);
if (rd.HasSavedData == true)
{
rd.Refresh();
}
string[] parm = report_parm.Split(',');
ParameterFields ParamFields = new ParameterFields();
for (int i = 0; i < rd.ParameterFields.Count; i++)
{
ParameterDiscreteValue ParamDiscreteValue = new ParameterDiscreteValue();
if (parm[i] != "[]")
{
ParamDiscreteValue.Value = parm[i].Replace(GlobeAtt.RPT_TEMP_INDEX, ",");
if (i < parm.Length && parm[i] != "")
{
rd.ParameterFields[i].CurrentValues.Add(ParamDiscreteValue);
}
}
}
CrystalReportViewer1.ReportSource = rd;
CrystalReportViewer1.DataBind();
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
return;
}
}
else
{
// string a002_key = Request.QueryString["A002KEY"] == null ? "-1" : Request.QueryString["A002KEY"].ToString();
// string A00201KEY = Request.QueryString["A00201KEY"] == null ? "-1" : Request.QueryString["A00201KEY"].ToString();
string report_conditon = Request.QueryString["reportconditon"] == null ? "1" : Request.QueryString["reportconditon"].ToString();
string key = Request.QueryString["JUMP_KEY"] == null ? "-1" : Request.QueryString["JUMP_KEY"].ToString();
string a002_key = Request.QueryString["JUMP_A002_KEY"] == null ? "-1" : Request.QueryString["JUMP_A002_KEY"].ToString();
string IF_JUMP = Request.QueryString["IF_JUMP"] == null ? "1" : Request.QueryString["IF_JUMP"].ToString();
// dt_a002 = Fun.getDtBySql("Select t.* from A002 t where menu_id='" + a002_key +"'");
dt_main = Fun.getDtBySql("Select t.*,pkg_a.getmenuname(t.a002_key,'" + GlobeAtt.A007_KEY + "') as show_name from A002_v01 t where a002_key='" + a002_key + "'");
try
{
report_file = dt_main.Rows[0]["datawindow_name"].ToString();
}
catch (Exception ex)
{
Response.Write("report_file" + ex.Message);
return;
}
try
{
menu_name = dt_main.Rows[0]["show_name"].ToString();
}
catch (Exception ex)
{
menu_name = "";
Response.Write("title" + ex.Message);
}
try
{
if (report_conditon == "1")
{
report_sql = dt_main.Rows[0]["query_table"].ToString();
if (report_sql.Length < 20)
{
report_sql = "Select t.* from " + report_sql + "t where 1=1 ";
}
Session["REPORT_SQL"] = report_sql;
}
else
{
report_sql = Session["REPORT_SQL"].ToString();
}
}
catch (Exception ex)
{
Response.Write("report_sql" + ex.Message);
return;
}
string file_ = Server.MapPath("../report/" + report_file);
try
{
rd.Load(file_);
ConnectionInfo ConnectionInfo1 = new ConnectionInfo();
ConnectionInfo1 = rd.Database.Tables[0].LogOnInfo.ConnectionInfo;
ConnectionInfo1.DatabaseName = "";
ConnectionInfo1.UserID = Fun.db.user_id;
ConnectionInfo1.Password = Fun.db.password;
ConnectionInfo1.ServerName = Fun.db.data_source;
SetDBLogonForReport(ConnectionInfo1, rd);
if (rd.HasSavedData == true)
{
rd.Refresh();
}
CrystalReportViewer1.ReportSource = rd;
CrystalReportViewer1.DataBind();
}
catch (Exception ex)
{
Response.Write(report_file + ex.Message);
return;
}
t_con.Visible = false;
Button1.Visible = false;
//else
//{
// cs = (CrystalReportSource) CrystalReportViewer1.ReportSource;
//}
/*
*
* if (report_conditon == "1")
* {
* set_condition();
* }
* else
* {
* // Response.Write(report_sql);
* t_con.Visible = false;
* Button1.Visible = false;
* //cs.ReportDocument.SetDatabaseLogon(Fun.db.user_id, Fun.db.password, Fun.db.data_source, Fun.db.data_source);
* //cs.ReportDocument.Refresh();
* // CrystalReportViewer1.ReportSource = cs;
* //CrystalReportViewer1.DataBind();
* // cs.DataBind();
* return;
* Oracle db = new Oracle();
* DataTable dt_report = new DataTable();
* db.ExcuteDataTable(dt_report, report_sql, CommandType.Text);
*
* cs.ReportDocument.SetDataSource(dt_report);
* cs.DataBind();
*
* CrystalReportViewer1.ReportSource = cs;
* CrystalReportViewer1.DataBind();
*
*
* }
*
*
*
* }
*
* // CryReport.get_report_condition(CrystalReportViewer1, Server.MapPath("../report/" + report_file), t_con);
*/
}
}
protected void Page_Load(object sender, EventArgs e)
{
ReturnCode = "0";
try
{
Stream RequestStream = Request.InputStream;
StreamReader RequestStreamReader = new StreamReader(RequestStream);
RequestXml = RequestStreamReader.ReadToEnd();
RequestStream.Close();
}
catch (Exception ex)
{
ReturnCode = "-1";
ReturnMessage = "错误报文格式！";
Error_Resp("0", "errorresp");
return;
}
string clientip = Fun.getClientIp();
// '&' (ampersand) becomes '&'
RequestXml = RequestXml.Replace("&", "&");
//'"' (double quote) becomes '"' when ENT_NOQUOTES is not set.
RequestXml = RequestXml.Replace(""", "\"");
//''' (single quote) becomes ''' only when ENT_QUOTES is set.
RequestXml = RequestXml.Replace("'", "'");
//'<' (less than) becomes '<'
RequestXml = RequestXml.Replace("<", "<");
//'>' (greater than) becomes '>'
RequestXml = RequestXml.Replace(">", ">");
SaveLog.Verification(clientip + ":" + RequestXml);
//获取MessageName
try
{
MessageName = BaseFun.getAllHyperLinks(RequestXml, "<messagename>", "</messagename>")[0].Value;
MessageName = MessageName.Substring(0, MessageName.Length - 3);
}
catch (Exception ex)
{
ReturnCode = "-1";
ReturnMessage = "错误报文格式(-1)!";
Error_Resp("0", "errorresp");
return;
}
try
{
//检测报文消息的有效性
string sql = "Select t.* from A319 t where a319_id='" + MessageName + "'";
DataTable dt_a319 = new DataTable();
dt_a319 = Fun.getDtBySql(sql);
if (dt_a319.Rows.Count == 0)
{
ReturnCode = "-1";
ReturnMessage = "错误报文格式(-2)！" + MessageName + sql;
Error_Resp("0", MessageName);
return;
}
if (dt_a319.Rows[0]["A319_TYPE"].ToString() == "0")
{
ReturnCode = "-1";
ReturnMessage = "错误报文格式(-3)!" + MessageName;
Error_Resp("0", MessageName);
return;
}
//检测报文状态失败有效
if (dt_a319.Rows[0]["STATE"].ToString() != "1")
{
ReturnCode = "-1";
ReturnMessage = "错误报文格式(-4)!" + MessageName;
Error_Resp("0", MessageName);
return;
}
//检测客户端的有效性
sql = dt_a319.Rows[0]["REQSQL"].ToString();
if (sql.Length > 10)
{
sql = sql.Replace("[CLIENTIP]", clientip);
DataTable dt_temp = new DataTable();
dt_temp = Fun.getDtBySql(sql);
if (dt_temp.Rows.Count <= 0)
{
ReturnCode = "-1";
ReturnMessage = "错误的客户端地址！" + MessageName;
Error_Resp("0", MessageName);
return;
}
}
sql = "Select s_a31902 .nextval as c from dual";
DataTable dt = new DataTable();
dt = Fun.getDtBySql(sql);
if (dt.Rows.Count <= 0)
{
ReturnCode = "-1";
ReturnMessage = "获取日志编码失败！" + MessageName;
Error_Resp("0", MessageName);
return;
}
log_key = dt.Rows[0][0].ToString();
//开始写日志
OracleParameter[] parmeters =
{
new OracleParameter("Messagename_", OracleType.NVarChar, 200),
new OracleParameter("A31902_Line_", OracleType.NVarChar, 200),
new OracleParameter("User_Id_", OracleType.NVarChar, 200),
new OracleParameter("Requestxml_", OracleType.Clob)
};
parmeters[0].Direction = ParameterDirection.Input;
parmeters[1].Direction = ParameterDirection.Input;
parmeters[2].Direction = ParameterDirection.Input;
parmeters[0].Value = MessageName;
parmeters[1].Value = log_key;
parmeters[2].Value = clientip;
parmeters[3].Value = RequestXml;
//写日志
int li_db = 0;
Fun.db.db_oracle.BeginTransaction();
try
{
li_db = Fun.db.db_oracle.ExecuteNonQuery("Pkg_a319_api.Save_Xml_", parmeters); //db.ExecuteNonQuery(str_sql, CommandType.Text);
if (li_db < 0)
{
Fun.db.db_oracle.Rollback();
ReturnCode = "-1";
ReturnMessage = "记录日志失败！" + MessageName;
Error_Resp("0", MessageName);
return;
}
}
catch (Exception ex)
{
Fun.db.db_oracle.Rollback();
ReturnCode = "-1";
ReturnMessage = BaseFun.GetOracleMsg(ex.Message);
Error_Resp("0", MessageName);
return;
}
Fun.db.db_oracle.Commit();
//处理报文
OracleParameter[] parm =
{
new OracleParameter("A31902_Line_", OracleType.NVarChar, 200)
};
parm[0].Direction = ParameterDirection.Input;
parm[0].Value = log_key;
//写日志
Fun.db.db_oracle.BeginTransaction();
try
{
li_db = Fun.db.db_oracle.ExecuteNonQuery("Pkg_a319_api.Req_xml_", parm); //db.ExecuteNonQuery(str_sql, CommandType.Text);
if (li_db < 0)
{
Fun.db.db_oracle.Rollback();
ReturnCode = "-1";
ReturnMessage = "处理失败！" + MessageName;
Error_Resp("0", MessageName);
return;
}
}
catch (Exception ex)
{
Fun.db.db_oracle.Rollback();
ReturnCode = "-1";
ReturnMessage = BaseFun.GetOracleMsg(ex.Message);
Error_Resp("0", MessageName);
return;
}
Fun.db.db_oracle.Commit();
// responsexml = parmeters[1].Value.ToString();
try
{
DataTable dt_send = new DataTable();
dt_send = Fun.getDtBySql("select t.sendxml from a31902 t where line_no=" + log_key);
Response.Write(dt_send.Rows[0][0].ToString());
}
catch
{
ReturnCode = "-1";
ReturnMessage = "处理失败！" + MessageName;
Error_Resp("0", MessageName);
}
}
catch
{
ReturnCode = "-1";
ReturnMessage = "处理失败！" + MessageName;
Error_Resp("0", MessageName);
}
}
