protected override void billAudit()
{
if (docFLAG.SelectedValue != "N")
{
Alert.Show("非新单不能审核！");
return;
}
string strBillno = (DbHelperOra.GetSingle(string.Format("SELECT B.BARCODE FROM DAT_XS_COM A,DAT_GOODSDS_LOG B WHERE A.STR1 = B.BARCODE AND B.FLAG <> 'N' AND A.SEQNO = '{0}' AND ROWNUM = 1", docSEQNO.Text)) ?? "").ToString();
//增加定数验证
if (!PubFunc.StrIsEmpty(strBillno))
{
Alert.Show("定数条码【" + strBillno + "】已被回收或退货", "提示信息", MessageBoxIcon.Warning);
return;
}
strBillno = docSEQNO.Text;
if (BillOper(strBillno, "AUDIT") == 1)
{
billLockDoc(true);
Alert.Show("单据【" + strBillno + "】审核成功！");
OperLog("定数回收", "审核单据【" + docBILLNO.Text + "】");
billOpen(strBillno);
}
}
protected void btnInitDept_Click(object sender, EventArgs e)
{
List <CommandInfo> cmdlist = new List <CommandInfo>();
OracleParameter[] parameters = { };
cmdlist.Add(new CommandInfo("INF_STORE.ZQRM_P_INIT_DEPT", parameters, CommandType.StoredProcedure));
try
{
if (DbHelperOra.ExecuteSqlTran(cmdlist))
{
Alert.Show("科室初始化执行成功！");
}
else
{
Alert.Show("科室初始化执行失败！");
}
}
catch (Exception ex)
{
Alert.Show(Error_Parse(ex.Message));
return;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SIMPLECOMMANDS GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,NAME,COMMENTS from SIMPLECOMMANDS ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.VarChar, 50)
};
parameters[0].Value = ID;
Model.SIMPLECOMMANDS model = new Model.SIMPLECOMMANDS();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public static bool saveDoc(MyTable MyTb, string tableName, string billNo)
{
List <CommandInfo> cmdList = new List <CommandInfo>();
try
{
MyTb.ColRow.Add("SUBSUM", DbHelperOra.GetSingle(string.Format("SELECT SUM(HSJE) FROM {0} WHERE SEQNO = '{1}'", tableName.Substring(0, tableName.Length - 3) + "COM", billNo)));
MyTb.ColRow.Add("SUBNUM", DbHelperOra.GetSingle(string.Format("SELECT COUNT(1) FROM {0} WHERE SEQNO = '{1}'", tableName.Substring(0, tableName.Length - 3) + "COM", billNo)));
}
catch
{
}
cmdList.Add(new CommandInfo(string.Format("DELETE {0} WHERE SEQNO='{1}'", tableName, billNo), null));//删除单据台头
cmdList.AddRange(MyTb.InsertCommand());
if (DbHelperOra.ExecuteSqlTran(cmdList))
{
return(true);
}
else
{
return(false);
}
}
private void LoadGridRow(DataRow row, bool firstRow = true, string flag = "NEW")
{
if (flag == "NEW")
{
//写入批次信息,货位
DataTable Temp = DbHelperOra.Query(string.Format("SELECT HWID,KCSL-LOCKSL KCSL,PH,YXQZ,RQ_SC FROM DAT_GOODSSTOCK WHERE DEPTID ='{0}' AND GDSEQ = '{1}' AND KCSL >LOCKSL AND ROWNUM = 1 ORDER BY PICINO ASC", docDEPTOUT.SelectedValue, row["GDSEQ"].ToString())).Tables[0];
if (Temp.Rows.Count > 0)
{
row["HWID"] = Temp.Rows[0]["HWID"];
row["KCSL"] = Temp.Rows[0]["KCSL"];
row["PH"] = Temp.Rows[0]["PH"];
row["YXQZ"] = Temp.Rows[0]["YXQZ"];
row["RQ_SC"] = Temp.Rows[0]["RQ_SC"];
}
else
{
//货位写入(重新取值)
object objHWID = DbHelperOra.GetSingle(string.Format("SELECT F_GETHWID('{0}','{1}') FROM DUAL", docDEPTOUT.SelectedValue, row["GDSEQ"].ToString()));
row["HWID"] = (objHWID ?? "").ToString();
row["KCSL"] = "0";
}
}
PubFunc.GridRowAdd(GridGoods, row, firstRow);
}
protected void RepeaterCat_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Web.UI.WebControls.HiddenField hdfCode = e.Item.FindControl("hfdCode") as System.Web.UI.WebControls.HiddenField;
Repeater repeaterCat = e.Item.FindControl("RepeaterCatN") as Repeater;
Object obj;
if (HttpContext.Current.Request.Cookies["DEPTOUT"] == null)
{
obj = "%";
}
else
{
obj = HttpContext.Current.Request.Cookies["DEPTOUT"].Value;
}
string strSqlCat = String.Format(@"SELECT CODE, NAME
FROM DOC_GOODSTYPE
WHERE ISDELETE = 'N'
AND EXISTS(SELECT 1 FROM SYS_DEPT WHERE TYPE IN ('3','4') AND CODE = '{1}')
AND CODE IN(SELECT DISTINCT A.CATID0 FROM DOC_GOODS A,DOC_GOODSCFG B,DOC_GOODSCFG C
WHERE A.FLAG = 'Y' AND A.GDSEQ = B.GDSEQ AND A.GDSEQ = C.GDSEQ AND C.DEPTID LIKE NVL('{0}','%') AND B.DEPTID = '{1}') ORDER BY CODE", obj.ToString(), UserAction.UserDept);
repeaterCat.DataSource = DbHelperOra.Query(strSqlCat).Tables[0];
repeaterCat.DataBind();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.COUNTRYCODE GetModel(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,NAME,CNAME,DIALINGPREFIX,TZONE from COUNTRYCODE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.VarChar, 2)
};
parameters[0].Value = ID;
Model.COUNTRYCODE model = new Model.COUNTRYCODE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DB.Model.TASK GetModel(string TASK_GUID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TASK_GUID,FILE_FULLNAME,ORDERED,PRINTING_TIME,SAVE_PATH,PRINTER,PAPER,ISPRINTING from TASK ");
strSql.Append(" where TASK_GUID=:TASK_GUID ");
OracleParameter[] parameters =
{
new OracleParameter(":TASK_GUID", OracleType.VarChar, 100)
};
parameters[0].Value = TASK_GUID;
DB.Model.TASK model = new DB.Model.TASK();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected override void billAudit()
{
//科室审核
if (docFLAG.SelectedValue != "N")
{
Alert.Show("单据未提交或者已审核！", "操作提示", MessageBoxIcon.Warning);
return;
}
string strBillno = docSEQNO.Text;
//唯一码是否扫描校验
if (DbHelperOra.Exists(String.Format("SELECT 1 FROM DAT_CK_EXT WHERE FLAG <>'Y' AND BILLNO = '{0}'", strBillno)))
{
Alert.Show("存在未扫描的高值码，请检查！", MessageBoxIcon.Warning);
btnScan_Click(null, null);
return;
}
if (BillOper(strBillno, "PASS2") == 1)
{
Alert.Show("单据【" + strBillno + "】审核成功！");
billOpen(strBillno);
OperLog("直接出库", "审核单据【" + docSEQNO.Text + "】");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.EX_HKCASE GetModel(string HK_APP_REF)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select HK_APP_REF,HK_APP_NO,HK_PUB_NO,HK_REG1_DATE,HK_PUB1_DATE,MAINTENANCE_DUEDATE,HK_REG2_DATE,NEXT_RENEWAL_DUEDATE,CN_APP_REF,CN_APP_NO,CN_APP_DATE,P4_SENDING_DATE,FIRST_AGENCY_REPORT,TO_PUB,P5_SENDING_DATE,SECOND_AGENCY_REPORT,TO_GRANT,COMMENTS,CLIENT_REF,CLIENT,HK_ANNO_NO,HK_GAZETTE,PARENT_COUNTRY,RECEIVED,ABANDON,PRIORITY,SENDADDRESS,ADDRCHECK,APPLICANT from EX_HKCASE ");
strSql.Append(" where HK_APP_REF=:HK_APP_REF ");
OracleParameter[] parameters =
{
new OracleParameter(":HK_APP_REF", OracleType.VarChar, 30)
};
parameters[0].Value = HK_APP_REF;
Model.EX_HKCASE model = new Model.EX_HKCASE();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.PATENTBILLITEMTYPE_V2 GetModel(string BILLCODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BILLCODE,BILLTEXT,PATENTCASETYPE,HASQUANTITY,UNIT,DEFOFFICIALFEE,DEFNONOFFICIALFEE,ALGORITHM,F0,F1,F2,F3,F4,F5,COMMENTS from PATENTBILLITEMTYPE_V2 ");
strSql.Append(" where BILLCODE=:BILLCODE ");
OracleParameter[] parameters =
{
new OracleParameter(":BILLCODE", OracleType.VarChar, 30)
};
parameters[0].Value = BILLCODE;
Model.PATENTBILLITEMTYPE_V2 model = new Model.PATENTBILLITEMTYPE_V2();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void bind()
{
String Sql = @"SELECT f_getdeptname(A.DEPTID) DEPTIDNAME,A.GDSEQ,A.SL,A.PH,A.RQ_SC,A.YXQZ,A.MEMO,
NVL(B.HISNAME,B.GDNAME) GDNAME,B.GDSPEC,f_getunitname(B.UNIT) UNITNAME,f_getproducername(A.STR1) PRODUCERNAME,f_getproducername(A.SUPPLIER) SUPPLIERNAME,
B.PIZNO,B.HSJJ,A.FLAG
FROM DAT_STOCK_IMP A, DOC_GOODS B
WHERE A.GDSEQ = B.GDSEQ(+) AND A.LRY = '{0}' ORDER BY A.FLAG";
int total = 0;
GridStock.DataSource = DbHelperOra.Query(String.Format(Sql, UserAction.UserID)).Tables[0];
DataTable dtData = PubFunc.DbGetPage(GridStock.PageIndex, GridStock.PageSize, String.Format(Sql, UserAction.UserID), ref total);
GridStock.RecordCount = total;
GridStock.DataSource = dtData;
GridStock.DataBind();
if (dtData.Rows.Count > 0)
{
btnSave.Enabled = true;
}
else
{
btnSave.Enabled = false;
}
}
/// <summary>
/// 获取单位编码的使用数量
/// </summary>
/// <param name="dwbm"></param>
/// <returns></returns>
public int GetDwbmCount(string dwbm)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select sum(s) s from(");
strSql.Append(" select count(1) as s from xt_zzjg_dwbm where fdwbm=" + dwbm + " and sfsc='N' and rownum =1 union ");
strSql.Append(" select count(1) from xt_zzjg_bmbm where dwbm=" + dwbm + " and sfsc='N' and rownum =1 union ");
strSql.Append(" select count(1) from xt_zzjg_rybm where dwbm=" + dwbm + " and sfsc='N' and rownum =1 union ");
strSql.Append(" select count(1) from tyyw_gg_ajjbxx where cbdw_bm=" + dwbm + " and sfsc='N' and rownum =1 union ");
strSql.Append(" select count(1) from xt_qx_jsbm where dwbm=" + dwbm + " and rownum =1 ) t");
int rows = -1;
try
{
object count = DbHelperOra.GetSingle(strSql.ToString());
rows = Convert.ToInt32(count);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public DataSet GetDwbmCount(string dwbm)", "EDRS.OracleDAL.XT_ZZJG_DWBM", strSql.ToString());
}
return(rows);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.BILL GetModel(string NOTENUMBER)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CASENO,NOTENUMBER,ISSUENUMBER,TYPE,ISSUED,PAID,STATUS,COMMENTS,ADDRESS,CLIENT,OWNER,CURRENCYID,ACCOUNTID,BILLING_START_DATE,BILLING_END_DATE,FIRMID,CLIENT_MATTERID,SIGS,DESCLINE from BILL ");
strSql.Append(" where NOTENUMBER=:NOTENUMBER ");
OracleParameter[] parameters =
{
new OracleParameter(":NOTENUMBER", OracleType.VarChar, 23)
};
parameters[0].Value = NOTENUMBER;
Model.BILL model = new Model.BILL();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.JOBTRACKING GetModel(string PID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select OURNO,PID,WORKERREF,JOBTYPE,AMOUNT,WORKERID,WORKERIDL2,ENTRUSTDATE,DUEDATE,COMPLETEDATE,SCORE,COMMENTS,ASSESSOR from JOBTRACKING ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 50)
};
parameters[0].Value = PID;
Model.JOBTRACKING model = new Model.JOBTRACKING();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public string Add(string drugcode, string supcode, string supname, string createman, string orgcode, string DdiCode)
{
if (exit(drugcode, DdiCode, orgcode) > 0)
{
return("当前查询码已经存在该商品信息，添加失败");
}
string datetime = DateTime.Now.ToString("yyy-MM-dd HH:mm:ss");
string sql = "INSERT INTO Sup_Drug_Add(SupCode,SupName,DrugCode,IsEnabled,OrgCode,CreateMan,CreateDate,StartDate,ForbiddenDate,ForbiddenMan,DdiCode) VALUES ('" + supcode + "','" + supname + "','" + drugcode + "','0','" + orgcode + "','" + createman + "',TO_DATE('" + datetime + "','yyyy-MM-dd HH24:MI:SS'), TO_DATE('" + datetime + "','yyyy-MM-dd HH24:MI:SS') ,null,null,'" + DdiCode + "')";
using (DbHelperOra _ora = new DbHelperOra(ConnName))
{
int result = _ora.ExecuteSql(sql.ToString());
if (result > 0)
{
return("添加成功");
}
else
{
return("添加失败");
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.DROPPING_TEMP_A model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DROPPING_TEMP_A set ");
strSql.Append("OURNO=:OURNO");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":OURNO", OracleType.VarChar, 50)
};
parameters[0].Value = model.OURNO;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public STBC.Model.ST_USERS GetModel(decimal USERID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select USERID,USERNAME,USERSEX,LEVELNAME,USERTRADE,USERCOMPANY,USERPOSITION,USERRESEARCH_FIELDS,PSW,PHOTO from ST_USERS ");
strSql.Append(" where USERID=:USERID ");
OracleParameter[] parameters =
{
new OracleParameter(":USERID", OracleDbType.Int32, 22)
};
parameters[0].Value = USERID;
STBC.Model.ST_USERS model = new STBC.Model.ST_USERS();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.GENERAL_INSTRUCTION GetModel(string PID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PID,CLIENT_NO,RECEIVED,RECEIVED_BY,RELATES_TO,CONTENT_CN,CONTENT_ORIGIN,INSTRUCTOR,STATUS,EXPIRE_DATE,COMMENTS from GENERAL_INSTRUCTION ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 40)
};
parameters[0].Value = PID;
Model.GENERAL_INSTRUCTION model = new Model.GENERAL_INSTRUCTION();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.CLASSIFIERTB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CLASSIFIERTB set ");
strSql.Append("ID=:ID,");
strSql.Append("CLASSNAME=:CLASSNAME,");
strSql.Append("COLUMNNAME=:COLUMNNAME,");
strSql.Append("SETSCALE=:SETSCALE,");
strSql.Append("COMMENTS=:COMMENTS");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.VarChar, 20),
new OracleParameter(":CLASSNAME", OracleType.VarChar, 80),
new OracleParameter(":COLUMNNAME", OracleType.VarChar, 20),
new OracleParameter(":SETSCALE", OracleType.VarChar, 50),
new OracleParameter(":COMMENTS", OracleType.VarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CLASSNAME;
parameters[2].Value = model.COLUMNNAME;
parameters[3].Value = model.SETSCALE;
parameters[4].Value = model.COMMENTS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.COUNTRYCODE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update COUNTRYCODE set ");
strSql.Append("ID=:ID,");
strSql.Append("NAME=:NAME,");
strSql.Append("CNAME=:CNAME,");
strSql.Append("DIALINGPREFIX=:DIALINGPREFIX,");
strSql.Append("TZONE=:TZONE");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.VarChar, 2),
new OracleParameter(":NAME", OracleType.VarChar, 100),
new OracleParameter(":CNAME", OracleType.VarChar, 200),
new OracleParameter(":DIALINGPREFIX", OracleType.VarChar, 10),
new OracleParameter(":TZONE", OracleType.VarChar, 5)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.NAME;
parameters[2].Value = model.CNAME;
parameters[3].Value = model.DIALINGPREFIX;
parameters[4].Value = model.TZONE;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.FCASE_LOG GetModel(string PID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PID,LOGDATE,CONTENT,OURNO,ITEM from FCASE_LOG ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 20)
};
parameters[0].Value = PID;
Model.FCASE_LOG model = new Model.FCASE_LOG();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void ScanSearch(string type)
{
string sql = "";
if (type == "SHOW")
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.GDSEQ,A.INSTIME DESC";
}
else
{
if (type == "SJSHOW")
{
sql = @"select B.GDSEQ,
B.GDNAME,
B.GDSPEC,
f_getunitname(b.unit) UNITNAME,
'1' BZHL,
A.PH,
'1' BZSL,
A.GDBARCODE ONECODE
from DAT_BARCODE_SJ A, DOC_GOODS B
WHERE A.GDSEQ = B.GDSEQ and a.rkseqno='{0}'
order by onecode";
}
else
{
sql = "SELECT A.*,f_getunitname(A.UNIT) UNITNAME FROM DAT_CK_EXT A WHERE A.BILLNO = '{0}' ORDER BY A.INSTIME DESC";
}
}
DataTable dtScan = DbHelperOra.Query(string.Format(sql, GridList.Rows[GridList.SelectedRowIndex].DataKeys[0])).Tables[0];
GridSacn.DataSource = dtScan;
GridSacn.DataBind();
zsmScan.Text = String.Empty;
zsmScan.Focus();
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.FCASE_LOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FCASE_LOG set ");
strSql.Append("PID=:PID,");
strSql.Append("LOGDATE=:LOGDATE,");
strSql.Append("CONTENT=:CONTENT,");
strSql.Append("OURNO=:OURNO,");
strSql.Append("ITEM=:ITEM");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 20),
new OracleParameter(":LOGDATE", OracleType.DateTime),
new OracleParameter(":CONTENT", OracleType.VarChar, 800),
new OracleParameter(":OURNO", OracleType.VarChar, 30),
new OracleParameter(":ITEM", OracleType.VarChar, 20)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.LOGDATE;
parameters[2].Value = model.CONTENT;
parameters[3].Value = model.OURNO;
parameters[4].Value = model.ITEM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btExport_Click(object sender, EventArgs e)
{
DataTable dtData = DbHelperOra.Query(GetSearchSql()).Tables[0];
if (dtData == null || dtData.Rows.Count == 0)
{
Alert.Show("没有数据,无法导出！");
return;
}
string[] columnNames = new string[GridGoods.Columns.Count - 1];
for (int index = 1; index < GridGoods.Columns.Count; index++)
{
GridColumn column = GridGoods.Columns[index];
if (column is FineUIPro.BoundField)
{
//dtData.Columns[((FineUI.BoundField)(column)).DataField.ToUpper()].DataType = Type.GetType("System.String");
dtData.Columns[((FineUIPro.BoundField)(column)).DataField.ToUpper()].ColumnName = column.HeaderText;
columnNames[index - 1] = column.HeaderText;
}
}
//((FineUI.Button)sender).Enabled = false;
XTBase.Utilities.ExcelHelper.ExportByWeb(dtData.DefaultView.ToTable(true, columnNames), "商品库存信息", string.Format("商品库存报表_{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmss")));
//((FineUI.Button)sender).Enabled = true;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public EDRS.Model.XT_QX_JSANQX GetModel(string QXBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select QXBM,ANBH,DWBM,JSBM,BMBM from XT_QX_JSANQX ");
strSql.Append(" where QXBM=:QXBM ");
OracleParameter[] parameters =
{
new OracleParameter(":QXBM", OracleType.VarChar, 50)
};
parameters[0].Value = QXBM;
EDRS.Model.XT_QX_JSANQX model = new EDRS.Model.XT_QX_JSANQX();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.ALERTTYPEGROUP GetModel(string GROUPID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select GROUPID,GROUPNAME,GROUPMEMBERS from ALERTTYPEGROUP ");
strSql.Append(" where GROUPID=:GROUPID ");
OracleParameter[] parameters =
{
new OracleParameter(":GROUPID", OracleType.VarChar, 20)
};
parameters[0].Value = GROUPID;
Model.ALERTTYPEGROUP model = new Model.ALERTTYPEGROUP();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_QX_JSANQX model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_QX_JSANQX set ");
strSql.Append("QXBM=:QXBM,");
strSql.Append("ANBH=:ANBH,");
strSql.Append("DWBM=:DWBM,");
strSql.Append("JSBM=:JSBM,");
strSql.Append("BMBM=:BMBM");
strSql.Append(" where QXBM=:QXBM ");
OracleParameter[] parameters =
{
new OracleParameter(":QXBM", OracleType.VarChar, 50),
new OracleParameter(":ANBH", OracleType.VarChar, 50),
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":JSBM", OracleType.Char, 3),
new OracleParameter(":BMBM", OracleType.Char, 4)
};
parameters[0].Value = model.QXBM;
parameters[1].Value = model.ANBH;
parameters[2].Value = model.DWBM;
parameters[3].Value = model.JSBM;
parameters[4].Value = model.BMBM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.DROPPING_HKPATENT GetModel(string HKNO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select HKNO,OURNO,CN_APPNO,CN_APPDATE,CN_PUBNO,CN_PUBDATE,CN_GRANTNO,CN_GRANTDATE,EARLIEST_MAINTENANCE_DATE,EARLIEST_RENEW_DATE,STEP1_DATE,STEP2_DATE from DROPPING_HKPATENT ");
strSql.Append(" where HKNO=:HKNO ");
OracleParameter[] parameters =
{
new OracleParameter(":HKNO", OracleType.VarChar, 30)
};
parameters[0].Value = HKNO;
Model.DROPPING_HKPATENT model = new Model.DROPPING_HKPATENT();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSrh_Click(object sender, EventArgs e)
{
if (ddlSUPID.SelectedValue.Length < 1)
{
Alert.Show("请选择结算【供应商】", MessageBoxIcon.Warning);
return;
}
//查询需结算单据
string Sql = string.Format(@"SELECT A.*,DECODE(A.FLAG,'J','已登记','D','部分结算','已结算') FLAGNAME,F_GET_BILLTYPENAME(A.BILLTYPE) BILLTYPENAME,f_getdeptname(A.DEPTOUT) DEPTOUTNAME,f_getdeptname(A.DEPTID) DEPTIDNAME,
DECODE(XSTYPE,'1','申领','申退') XSTYPENAME,f_getusername(A.LRY) LRYNAME,f_getusername(A.SHR) SHRNAME,ABS((SELECT SUM(HSJE) FROM DAT_GOODSJXC B WHERE NVL(B.PSSID,B.SUPID) = '{2}' AND B.BILLNO = A.SEQNO AND NVL(STR1,'#') = '#')) SUPSUM
FROM DAT_XS_DOC A, DAT_XS_COM B
WHERE A.SEQNO=B.SEQNO AND A.FLAG IN ('J','D') AND A.SHRQ BETWEEN TO_DATE('{0}','YYYY-MM-DD') AND TO_DATE('{1}','YYYY-MM-DD') + 1 AND A.BILLTYPE='XSG'
AND EXISTS(SELECT 1 FROM DAT_GOODSJXC B WHERE NVL(B.PSSID,B.SUPID) = '{2}' AND B.BILLNO = A.SEQNO AND NVL(STR1,'#') = '#')", docJSKS.Text, docJSJS.Text, ddlSUPID.SelectedValue);
string strSearch = "";
if (docDEPTID.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID LIKE '{0}'", docDEPTID.SelectedValue);
}
if (ddlNUM2.SelectedValue == "G")
{
strSearch += string.Format(" AND B.ISGZ LIKE '{0}'", "Y");
}
else
{
strSearch += string.Format(" AND B.ISGZ LIKE '{0}'", "N");
}
if (tgbCKDH.Text.Length > 0)
{
strSearch += string.Format(" AND A.SEQNO LIKE '%{0}%'", tgbCKDH.Text);
}
strSearch += " ORDER BY A.DEPTID,A.SEQNO DESC";
GridGoods.DataSource = DbHelperOra.Query(Sql + strSearch).Tables[0];
GridGoods.DataBind();
}
