/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string PID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from GENERAL_INSTRUCTION ");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 40)
};
parameters[0].Value = PID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string BM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from YX_DZJZ_FMDYMB ");
strSql.Append(" where BM=:BM ");
OracleParameter[] parameters =
{
new OracleParameter(":BM", OracleType.NVarChar)
};
parameters[0].Value = BM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string FEEID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from BILLFEEMNT ");
strSql.Append(" where FEEID=:FEEID ");
OracleParameter[] parameters =
{
new OracleParameter(":FEEID", OracleType.VarChar, 50)
};
parameters[0].Value = FEEID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from COUNTRYCODE ");
strSql.Append(" where ID=:ID ");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.VarChar, 2)
};
parameters[0].Value = ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string strSeq = hfdSEQ.Text.ToString();
if (PubFunc.StrIsEmpty(strSeq))
{
return;
}
if (ddlSTATUS.SelectedValue != "5")
{
Alert.Show("当前问题状态【" + ddlSTATUS.SelectedText + "】还没有关闭，不能删除！！", "消息提示", MessageBoxIcon.Information);
return;
}
DbHelperOra.ExecuteSql("delete FROM PRO_QUESTION WHERE SEQ='" + strSeq + "'");
Alert.Show("当前问题信息删除成功！", "消息提示", MessageBoxIcon.Information);
billNew();
DataSearch();
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string BILLTYPE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from BILLTYPE ");
strSql.Append(" where BILLTYPE=:BILLTYPE ");
OracleParameter[] parameters =
{
new OracleParameter(":BILLTYPE", OracleType.VarChar, 15)
};
parameters[0].Value = BILLTYPE;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(decimal USERID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from ST_USERS ");
strSql.Append(" where USERID=:USERID ");
OracleParameter[] parameters =
{
new OracleParameter(":USERID", OracleDbType.Int32, 22)
};
parameters[0].Value = USERID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string NAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from COUNTRY_TRANSLATION ");
strSql.Append(" where NAME=:NAME ");
OracleParameter[] parameters =
{
new OracleParameter(":NAME", OracleType.VarChar, 30)
};
parameters[0].Value = NAME;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string OURNO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from TMCASE ");
strSql.Append(" where OURNO=:OURNO ");
OracleParameter[] parameters =
{
new OracleParameter(":OURNO", OracleType.VarChar, 18)
};
parameters[0].Value = OURNO;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string QXBM)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from XT_QX_JSANQX ");
strSql.Append(" where QXBM=:QXBM ");
OracleParameter[] parameters =
{
new OracleParameter(":QXBM", OracleType.VarChar, 50)
};
parameters[0].Value = QXBM;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string CLIENTID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from CLIENTDB ");
strSql.Append(" where CLIENTID=:CLIENTID ");
OracleParameter[] parameters =
{
new OracleParameter(":CLIENTID", OracleType.Char, 4)
};
parameters[0].Value = CLIENTID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 额度变化记录
/// </summary>
/// <param name="n_id"></param>
/// <param name="n_date"></param>
/// <param name="n_type"></param>
/// <param name="n_uid"></param>
/// <param name="n_creditbefer"></param>
/// <param name="n_creitafter"></param>
public void InsertCreditLog(int n_id, DateTime n_date, string n_type, string n_uid, decimal n_creditbefer, decimal n_creitafter)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into kfb_hycreditlog(n_id, n_date, n_type, n_uid, n_creditbefer, n_creitafter) ");
strSql.Append("values(:n_id, :n_date, :n_type, :n_uid, :n_creditbefer, :n_creitafter)");
OracleParameter[] parameters =
{
new OracleParameter(":n_id", OracleType.Number),
new OracleParameter(":n_date", OracleType.DateTime),
new OracleParameter(":n_type", OracleType.Char, 1),
new OracleParameter(":n_uid", OracleType.VarChar, 50),
new OracleParameter(":n_creditbefer", OracleType.Number),
new OracleParameter(":n_creitafter", OracleType.Number)
};
parameters[0].Value = n_id;
parameters[1].Value = n_date;
parameters[2].Value = n_type;
parameters[3].Value = n_uid;
parameters[4].Value = n_creditbefer;
parameters[5].Value = n_creitafter;
DbHelperOra.ExecuteSql(conn, tran, strSql.ToString(), parameters);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string HK_APP_REF)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete 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;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 取新ID
/// </summary>
/// <param name="dbs">配置信息</param>
/// <param name="tablename">表名</param>
/// <returns>ID值</returns>
public int NewTableID(string tablename = "YX_DZJZ_JZRZJL")
{
string sql = "";//"select * from sqlite_master where type = 'table' and name = 'yy_tableid'";
sql = String.Format("select TableID from MC_TABLEID where NAME = '{0}'", tablename);
object returnValue = DbHelperOra.GetSingle(sql);
int newid = 1;
if (returnValue == null || returnValue == DBNull.Value)
{
sql = String.Format("insert into MC_TABLEID (NAME,TABLEID) values ('{0}',2)", tablename);
DbHelperOra.ExecuteSql(sql);
}
else
{
newid = int.Parse(returnValue.ToString());
int rid = newid + 1;
sql = String.Format("update MC_TABLEID set TABLEID = {0} where NAME = '{1}'", rid, tablename);
DbHelperOra.ExecuteSql(sql);
newid = rid;
}
return(newid);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string NOTENUMBER)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from BILL ");
strSql.Append(" where NOTENUMBER=:NOTENUMBER ");
OracleParameter[] parameters =
{
new OracleParameter(":NOTENUMBER", OracleType.VarChar, 23)
};
parameters[0].Value = NOTENUMBER;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string FNAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from FBKUPINFO ");
strSql.Append(" where FNAME=:FNAME ");
OracleParameter[] parameters =
{
new OracleParameter(":FNAME", OracleType.VarChar, 200)
};
parameters[0].Value = FNAME;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string CASENO, string CLIENTNO, string VOUCHERNO, string FEETYPE, decimal AMOUNT, string PAYMETHOD, DateTime PAYDATE, string TRADEMARKNAME)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from SBFEEDETAIL ");
strSql.Append(" where CASENO=:CASENO and CLIENTNO=:CLIENTNO and VOUCHERNO=:VOUCHERNO and FEETYPE=:FEETYPE and AMOUNT=:AMOUNT and PAYMETHOD=:PAYMETHOD and PAYDATE=:PAYDATE and TRADEMARKNAME=:TRADEMARKNAME ");
OracleParameter[] parameters =
{
new OracleParameter(":CASENO", OracleType.VarChar, 50),
new OracleParameter(":CLIENTNO", OracleType.VarChar, 10),
new OracleParameter(":VOUCHERNO", OracleType.VarChar, 20),
new OracleParameter(":FEETYPE", OracleType.VarChar, 40),
new OracleParameter(":AMOUNT", OracleType.Number, 22),
new OracleParameter(":PAYMETHOD", OracleType.VarChar, 40),
new OracleParameter(":PAYDATE", OracleType.DateTime),
new OracleParameter(":TRADEMARKNAME", OracleType.VarChar, 100)
};
parameters[0].Value = CASENO;
parameters[1].Value = CLIENTNO;
parameters[2].Value = VOUCHERNO;
parameters[3].Value = FEETYPE;
parameters[4].Value = AMOUNT;
parameters[5].Value = PAYMETHOD;
parameters[6].Value = PAYDATE;
parameters[7].Value = TRADEMARKNAME;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(STBC.Model.ST_FUZZFUNCT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ST_FUZZFUNCT(");
strSql.Append("ID,FACTID,UNIT,INFLEXION,FUNCTTYPE,MEASNAME,USERID)");
strSql.Append(" values (");
strSql.Append(":ID,:FACTID,:UNIT,:INFLEXION,:FUNCTTYPE,:MEASNAME,:USERID)");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleDbType.Int32, 7),
new OracleParameter(":FACTID", OracleDbType.Int32, 7),
new OracleParameter(":UNIT", OracleDbType.Varchar2, 20),
new OracleParameter(":INFLEXION", OracleDbType.Varchar2, 200),
new OracleParameter(":FUNCTTYPE", OracleDbType.Varchar2, 20),
new OracleParameter(":MEASNAME", OracleDbType.Varchar2, 100),
new OracleParameter(":USERID", OracleDbType.Int32, 7)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.FACTID;
parameters[2].Value = model.UNIT;
parameters[3].Value = model.INFLEXION;
parameters[4].Value = model.FUNCTTYPE;
parameters[5].Value = model.MEASNAME;
parameters[6].Value = model.USERID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public string addresadd(HttpContext context)
{
string userid = context.Request["str1"] == null ? "" : context.Request["str1"].ToString(); //获取参数
string name = context.Request["name"] == null ? "" : context.Request["name"].ToString(); //获取参数;
string ads = context.Request["ads"] == null ? "" : context.Request["ads"].ToString(); //获取参数
string tel = context.Request["tel"] == null ? "" : context.Request["tel"].ToString(); //获取参数
string area = context.Request["area"] == null ? "" : context.Request["area"].ToString(); //获取参数
string seqno = context.Request["seqno"] == null ? "" : context.Request["seqno"].ToString(); //获取参数
string strResult = "";
if (!string.IsNullOrEmpty(seqno))
{
string sqlDel = string.Format(@"DELETE FROM DOC_ADDRESS WHERE FSEQNO = '{0}'", seqno);
DbHelperOra.ExecuteSql(sqlDel);
}
else
{
seqno = (DbHelperOra.GetSingle("select seq_address.nextval from dual")).ToString();
}
string sql = "";
if (DbHelperOra.ExecuteSql(sql) > 0)
{
strResult = new JObject(
new JProperty("res", "1"),
new JProperty("msg", "")
).ToString();
}
else
{
strResult = new JObject(
new JProperty("res", "0"),
new JProperty("msg", "")
).ToString();
}
return(strResult);
}
private void save(String value)
{
if (hdfPSSID.Text == null || hdfPSSID.Text == "" || tleSUPNAME.Text == null || tleSUPNAME.Text == "" || tleBILLNO.Text == null || tleBILLNO.Text == "")
{
Alert.Show("请选定评价目标", MessageBoxIcon.Warning); return;
}
if (value == "0")
{
Alert.Show("请标注评价等级", MessageBoxIcon.Warning); return;
}
if (rblNUM1.SelectedIndex < 0)
{
Alert.Show("请标注包装外观检查结果", MessageBoxIcon.Warning); return;
}
if (rblNUM2.SelectedIndex < 0)
{
Alert.Show("请标注数量检查结果", MessageBoxIcon.Warning); return;
}
if (rblNUM3.SelectedIndex < 0)
{
Alert.Show("请标注评抽检结果", MessageBoxIcon.Warning); return;
}
if (rblSTR5.SelectedIndex < 0)
{
Alert.Show("请标注供货及时率", MessageBoxIcon.Warning); return;
}
if (txaMEMO.Text.Length > 50)
{
Alert.Show("详细说明内容超长", MessageBoxIcon.Warning); return;
}
if (DbHelperOra.ExecuteSql(string.Format("INSERT INTO DAT_SUPEVALUATE (SUPID,BILLNO,GRADE,PJR,MEMO,NUM1,NUM2,NUM3,STR5) VALUES ('{0}','{1}', '{2}','{3}','{4}','{5}','{6}','{7}','{8}') ", hdfPSSID.Text.Trim(), tleBILLNO.Text.Trim(), value, UserAction.UserID, txaMEMO.Text, rblNUM1.SelectedIndex, rblNUM2.SelectedIndex, rblNUM3.SelectedIndex, rblSTR5.SelectedValue)) > 0)
{
Alert.Show("评价成功");
billopen(tleBILLNO.Text.Trim(), hdfPSSID.Text.Trim());
return;
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(string DWBM, string BMBM, string JSBM, string GH)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from XT_QX_RYJSFP ");
strSql.Append(" where DWBM=:DWBM and BMBM=:BMBM and JSBM=:JSBM and GH=:GH ");
OracleParameter[] parameters =
{
new OracleParameter(":DWBM", OracleType.VarChar, 50),
new OracleParameter(":BMBM", OracleType.Char, 4),
new OracleParameter(":JSBM", OracleType.Char, 3),
new OracleParameter(":GH", OracleType.Char, 4)
};
parameters[0].Value = DWBM;
parameters[1].Value = BMBM;
parameters[2].Value = JSBM;
parameters[3].Value = GH;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Delete(string DWBM,string BMBM,string JSBM,string GH)", "EDRS.OracleDAL.XT_QX_RYJSFP", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnRejectSubmit_Click(object sender, EventArgs e)
{
if (docFLAG.SelectedValue != "N" || docBILLNO.Text.Length == 0)
{
Alert.Show("已提交不能驳回！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (!docBILLNO.Text.Contains(BillType) && docBILLNO.Text.Length > 0)
{
Alert.Show("下传单据不能驳回！", "消息提示", MessageBoxIcon.Warning);
return;
}
if (docBILLNO.Text.Length < 1)
{
return;
}
if (string.IsNullOrWhiteSpace(ddlReject.SelectedValue))
{
Alert.Show("请选择驳回原因", "消息提示", MessageBoxIcon.Warning);
return;
}
string strMemo = "驳回原因：" + ddlReject.SelectedText;
if (!string.IsNullOrWhiteSpace(txaMemo.Text.Trim()))
{
strMemo += "；详细说明：" + txaMemo.Text;
}
if (DbHelperOra.ExecuteSql(string.Format("update DAT_YRK_DOC set flag='R',memo='{0}' where seqno='{1}' and flag='N'", strMemo, docBILLNO.Text)) == 1)
{
WindowReject.Hidden = true;
billOpen(docBILLNO.Text);
}
;
}
public int AddTreeNode(PZYM.Shop.Model.SysNode model)
{
model.NodeID = GetMaxId();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into S_Tree(");
strSql.Append("NodeID,Text,ParentID,Location,OrderID,comment,Url,PermissionID,ImageUrl)");
strSql.Append(" values (");
strSql.Append("@NodeID,@Text,@ParentID,@Location,@OrderID,@comment,@Url,@PermissionID,@ImageUrl)");
//
OracleParameter[] parameters =
{
new OracleParameter("@NodeID", OracleType.Number, 4),
new OracleParameter("@Text", OracleType.VarChar, 100),
new OracleParameter("@ParentID", OracleType.Int32, 4),
new OracleParameter("@Location", OracleType.VarChar, 50),
new OracleParameter("@OrderID", OracleType.Int32, 4),
new OracleParameter("@comment", OracleType.VarChar, 50),
new OracleParameter("@Url", OracleType.VarChar, 100),
new OracleParameter("@PermissionID", OracleType.Int32, 4),
new OracleParameter("@ImageUrl", OracleType.VarChar, 100)
};
parameters[0].Value = model.NodeID;
parameters[1].Value = model.Text;
parameters[2].Value = model.ParentID;
parameters[3].Value = model.Location;
parameters[4].Value = model.OrderID;
parameters[5].Value = model.Comment;
parameters[6].Value = model.Url;
parameters[7].Value = model.PermissionID;
parameters[8].Value = model.ImageUrl;
DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
return(model.NodeID);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.XT_DZJZ_SSLB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into XT_DZJZ_SSLB(");
strSql.Append("SSLBBM,FSSLBBM,SSLBLX,SSLBMC,SSLBSX,SSLBSM)");
strSql.Append(" values (");
strSql.Append(":SSLBBM,:FSSLBBM,:SSLBLX,:SSLBMC,:SSLBSX,:SSLBSM)");
OracleParameter[] parameters =
{
new OracleParameter(":SSLBBM", OracleType.Char, 13),
new OracleParameter(":FSSLBBM", OracleType.Char, 13),
new OracleParameter(":SSLBLX", OracleType.Char, 1),
new OracleParameter(":SSLBMC", OracleType.VarChar, 300),
new OracleParameter(":SSLBSX", OracleType.Number, 8),
new OracleParameter(":SSLBSM", OracleType.VarChar, 4000)
};
parameters[0].Value = model.SSLBBM;
parameters[1].Value = model.FSSLBBM;
parameters[2].Value = model.SSLBLX;
parameters[3].Value = model.SSLBMC;
parameters[4].Value = model.SSLBSX;
parameters[5].Value = model.SSLBSM;
try
{
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.XT_DZJZ_SSLB model)", "EDRS.OracleDAL.XT_DZJZ_SSLB", strSql.ToString(), parameters);
}
return(false);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(EDRS.Model.XT_DZJZ_JZMB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update XT_DZJZ_JZMB set ");
strSql.Append("AJLB=:AJLB,");
strSql.Append("SYCH=:SYCH");
strSql.Append(" where MBJZBH=:MBJZBH ");
OracleParameter[] parameters =
{
new OracleParameter(":AJLB", OracleType.VarChar, 50),
new OracleParameter(":SYCH", OracleType.Char, 1),
new OracleParameter(":MBJZBH", OracleType.Char, 14)
};
parameters[0].Value = model.AJLB;
parameters[1].Value = model.SYCH;
parameters[2].Value = model.MBJZBH;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Update(EDRS.Model.XT_DZJZ_JZMB model)", "EDRS.OracleDAL.XT_DZJZ_JZMB", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.CHANGELOG model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CHANGELOG(");
strSql.Append("ACT_DATE,OURNO,ACTION,COL_NAME,OLD_VAL,NEW_VAL,CUR_USER)");
strSql.Append(" values (");
strSql.Append(":ACT_DATE,:OURNO,:ACTION,:COL_NAME,:OLD_VAL,:NEW_VAL,:CUR_USER)");
OracleParameter[] parameters =
{
new OracleParameter(":ACT_DATE", OracleType.DateTime),
new OracleParameter(":OURNO", OracleType.VarChar, 24),
new OracleParameter(":ACTION", OracleType.Char, 1),
new OracleParameter(":COL_NAME", OracleType.VarChar, 20),
new OracleParameter(":OLD_VAL", OracleType.VarChar, 300),
new OracleParameter(":NEW_VAL", OracleType.VarChar, 300),
new OracleParameter(":CUR_USER", OracleType.VarChar, 20)
};
parameters[0].Value = model.ACT_DATE;
parameters[1].Value = model.OURNO;
parameters[2].Value = model.ACTION;
parameters[3].Value = model.COL_NAME;
parameters[4].Value = model.OLD_VAL;
parameters[5].Value = model.NEW_VAL;
parameters[6].Value = model.CUR_USER;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(EDRS.Model.YX_DZJZ_LSAJWJFP model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into YX_DZJZ_LSAJWJFP(");
strSql.Append("YJXH,WJXH,SFSC)");
strSql.Append(" values (");
strSql.Append(":YJXH,:WJXH,:SFSC)");
OracleParameter[] parameters =
{
new OracleParameter(":YJXH", OracleType.VarChar, 50),
new OracleParameter(":WJXH", OracleType.VarChar, 100),
new OracleParameter(":SFSC", OracleType.Char, 1)
};
parameters[0].Value = model.YJXH;
parameters[1].Value = model.WJXH;
parameters[2].Value = model.SFSC;
int rows = 0;
try
{
rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}
catch (Exception ex)
{
EDRS.Common.LogHelper.LogError(this.context, "Exception", ex.Message, "public bool Add(EDRS.Model.YX_DZJZ_LSAJWJFP model)", "EDRS.OracleDAL.YX_DZJZ_LSAJWJFP", strSql.ToString(), parameters);
}
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.FCASE_REL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update FCASE_REL set ");
strSql.Append("PID=:PID,");
strSql.Append("EARLIER=:EARLIER,");
strSql.Append("LATER=:LATER,");
strSql.Append("RELATION=:RELATION,");
strSql.Append("EXPLANATION=:EXPLANATION");
strSql.Append(" where PID=:PID ");
OracleParameter[] parameters =
{
new OracleParameter(":PID", OracleType.VarChar, 20),
new OracleParameter(":EARLIER", OracleType.VarChar, 30),
new OracleParameter(":LATER", OracleType.VarChar, 30),
new OracleParameter(":RELATION", OracleType.VarChar, 10),
new OracleParameter(":EXPLANATION", OracleType.VarChar, 200)
};
parameters[0].Value = model.PID;
parameters[1].Value = model.EARLIER;
parameters[2].Value = model.LATER;
parameters[3].Value = model.RELATION;
parameters[4].Value = model.EXPLANATION;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加民意档案数据
/// </summary>
/// <param name="con_guid">民意档案id</param>
/// <param name="title">标题</param>
/// <param name="content">反映内容</param>
/// <param name="intnum">96122formid</param>
/// <returns></returns>
private int AddJLYEE(string con_guid, string title, string content, string intnum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CON_JLYEE(");
strSql.Append("ID,BH,BT,FYNR,JBRQ,CJR,CJSJ,ZT,FYRQ,INTNUM)");
strSql.Append(" values (");
strSql.Append(":ID,:BH,:BT,:FYNR,:JBRQ,:CJR,:CJSJ,:ZT,:FYRQ,:INTNUM)");
OracleParameter[] parameters =
{
new OracleParameter(":ID", OracleType.VarChar, 36),
new OracleParameter(":BH", OracleType.VarChar, 100),
new OracleParameter(":BT", OracleType.VarChar, 500),
new OracleParameter(":FYNR", OracleType.Clob),
new OracleParameter(":JBRQ", OracleType.DateTime),
new OracleParameter(":CJR", OracleType.VarChar, 36),
new OracleParameter(":CJSJ", OracleType.DateTime),
new OracleParameter(":ZT", OracleType.Int32, 1),
new OracleParameter(":FYRQ", OracleType.DateTime),
new OracleParameter(":INTNUM", OracleType.VarChar, 50)
};
parameters[0].Value = con_guid;
parameters[1].Value = intnum;
parameters[2].Value = title;
parameters[3].Value = content;
parameters[4].Value = DateTime.Now;
parameters[5].Value = "96122";
parameters[6].Value = DateTime.Now;
parameters[7].Value = 1;
parameters[8].Value = DateTime.Now;
parameters[9].Value = intnum;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
return(rows);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(KFB_ZHGL model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update KFB_ZHGL set ");
strSql.Append("N_HYZH=:N_HYZH,");
strSql.Append("N_HYMM=:N_HYMM,");
strSql.Append("N_HYMC=:N_HYMC,");
strSql.Append("N_HYDJ=:N_HYDJ,");
strSql.Append("N_XZSJ=:N_XZSJ,");
strSql.Append("N_HYJRSJ=:N_HYJRSJ,");
strSql.Append("N_HYXG=:N_HYXG,");
strSql.Append("N_YXDL=:N_YXDL");
strSql.Append(" where N_HYZH=:N_HYZH ");
OracleParameter[] parameters =
{
new OracleParameter(":N_HYZH", OracleType.VarChar, 100),
new OracleParameter(":N_HYMM", OracleType.VarChar, 100),
new OracleParameter(":N_HYMC", OracleType.VarChar, 100),
new OracleParameter(":N_HYDJ", OracleType.Number, 4),
new OracleParameter(":N_XZSJ", OracleType.DateTime),
new OracleParameter(":N_HYJRSJ", OracleType.DateTime),
new OracleParameter(":N_HYXG", OracleType.DateTime),
new OracleParameter(":N_YXDL", OracleType.Number, 4)
};
parameters[0].Value = model.N_HYZH;
parameters[1].Value = model.N_HYMM;
parameters[2].Value = model.N_HYMC;
parameters[3].Value = model.N_HYDJ;
parameters[4].Value = model.N_XZSJ;
parameters[5].Value = model.N_HYJRSJ;
parameters[6].Value = model.N_HYXG;
parameters[7].Value = model.N_YXDL;
DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
}