//获取帐户短信可用数量
public static int GetBalance()
{
int Id = 300;//机构代码
try
{
Id = Convert.ToInt32(ApiClientUtil.GetConfigCont("MESSAGE_ID"));
}
catch
{ }
string Name = ApiClientUtil.GetConfigCont("MESSAGE_NAME"); //账户名
string Psw = ApiClientUtil.GetConfigCont("MESSAGE_PWD"); //密码
string webServiceURL = ApiClientUtil.GetConfigCont("MESSAGE_WEBSERVICEURL"); //webService地址
//GetBalance(int Id, string Name, string Psw)
int Balance = -1;
object BalanceState = null;
try
{
BalanceState = DynamicServiceBind.InvokeWebService(webServiceURL, "GetBalance", new object[] { Id, Name, Psw });
}
catch (Exception e)
{
throw e;
}
if (BalanceState != null)
{
System.Reflection.FieldInfo fieldInfoBalance = BalanceState.GetType().GetField("Balance");
Balance = (int)fieldInfoBalance.GetValue(BalanceState);
}
return(Balance);
}
//发送短信
public static object SendMessage(string sendDoc, string getTel)
{
int Id = 300;//机构代码
try
{
Id = Convert.ToInt32(ApiClientUtil.GetConfigCont("MESSAGE_ID"));
}
catch
{ }
string Name = ApiClientUtil.GetConfigCont("MESSAGE_NAME"); //账户名
string Psw = ApiClientUtil.GetConfigCont("MESSAGE_PWD"); //密码
string webServiceURL = ApiClientUtil.GetConfigCont("MESSAGE_WEBSERVICEURL"); //webService地址
long Timestamp = GetTimeStamp();
//SendMessage(int Id, string Name, string Psw, string Message, string Phone, int Timestamp)
object result = null;
try
{
//Message.ServiceSoap. service= new Message.ServiceSoap();
//Messages.ServiceSoapClient ser = new Messages.ServiceSoapClient();
//Messages.SendState c= ser.SendMessage(Id,Name,Psw,sendDoc,getTel,Timestamp);
//result = c.Id.ToString() + "|" + c.State + "|" + c.FailPhone;
result = DynamicServiceBind.InvokeWebService(webServiceURL, "SendMessage", new object[] { Id, Name, Psw, sendDoc, getTel, Timestamp });
}
catch (Exception e)
{
}
return(result);
}
//定时发送短信
public static object SendMessageTimer(string sendDoc, string getTel, string sendDatetime)
{
int Id = 300;//机构代码
try
{
Id = Convert.ToInt32(ApiClientUtil.GetConfigCont("MESSAGE_ID"));
}
catch
{ }
string Name = ApiClientUtil.GetConfigCont("MESSAGE_NAME"); //账户名
string Psw = ApiClientUtil.GetConfigCont("MESSAGE_PWD"); //密码
string webServiceURL = ApiClientUtil.GetConfigCont("MESSAGE_WEBSERVICEURL"); //webService地址
long Timestamp = GetTimeStamp();
//SendTimer(int Id, string Name, string Psw, string Message, string Phone,String DateTime, long Timestamp)
object result = "";
try
{
result = DynamicServiceBind.InvokeWebService(webServiceURL, "SendTimer", new object[] { Id, Name, Psw, sendDoc, getTel, sendDatetime, Timestamp });
}
catch (Exception e)
{
}
return(result);
}
private void billOpen(string strSeq)
{
TabStrip1.ActiveTabIndex = 1;
String prefix = ApiClientUtil.GetConfigCont("LICENSE_PATH");
gridPic.DataSource = getPicData(strSeq);
gridPic.DataBind();
//imgBMPPATH.ImageUrl = "http://localhost:3788/captcha/CertificatePicture.aspx?seqno="+strSeq+"&rowno=1";
imgBMPPATH.ImageUrl = ApiUtil.GetConfigCont("LICENSE_PATH") + "/captcha/CertificatePicture.aspx?seqno=" + strSeq + "&rowno=1";
}
protected void gridPic_RowClick(object sender, GridRowClickEventArgs e)
{
TabStrip1.ActiveTabIndex = 1;
String prefix = ApiClientUtil.GetConfigCont("LICENSE_PATH");
string seqno = gridPic.Rows[e.RowIndex].DataKeys[0].ToString();
string rowno = gridPic.Rows[e.RowIndex].DataKeys[1].ToString();
DataTable dt = gridPic_path(seqno, rowno);
if (dt.Rows.Count > 0)
{
imgBMPPATH.ImageUrl = prefix + dt.Rows[0]["PICPATH"].ToString().Replace("~", "");
}
else
{
Alert.Show("不要频繁点击，稍后片刻！");
}
}
private void billOpen(string strSeq)
{
TabStrip1.ActiveTabIndex = 1;
String prefix = ApiClientUtil.GetConfigCont("LICENSE_PATH");
gridPic.DataSource = getPicData(strSeq);
gridPic.DataBind();
imgBMPPATH.ImageUrl = ApiUtil.GetConfigCont("LICENSE_PATH") + "/captcha/CertificatePicture.aspx?seqno=" + strSeq + "&rowno=1";
//DataTable mydt = gridPic_path1(strSeq);
//if (mydt.Rows.Count > 0)
//{
// imgBMPPATH.ImageUrl = prefix + mydt.Rows[0]["PICPATH"].ToString().Replace("~", "");
//}
//else
//{
// Alert.Show("不要频繁点击，稍后片刻！");
//}
}
protected void gridPic_RowClick(object sender, GridRowClickEventArgs e)
{
TabStrip1.ActiveTabIndex = 1;
String prefix = ApiClientUtil.GetConfigCont("LICENSE_PATH");
string seqno = gridPic.Rows[e.RowIndex].DataKeys[0].ToString();
string rowno = gridPic.Rows[e.RowIndex].DataKeys[1].ToString();
imgBMPPATH.ImageUrl = ApiUtil.GetConfigCont("LICENSE_PATH") + "/captcha/CertificatePicture.aspx?seqno=" + seqno + "&rowno=" + rowno;
//DataTable dt = gridPic_path(seqno, rowno);
//if (dt.Rows.Count > 0)
//{
// imgBMPPATH.ImageUrl = prefix + dt.Rows[0]["PICPATH"].ToString().Replace("~", "");
//}
//else
//{
// Alert.Show("不要频繁点击，稍后片刻！");
//}
}
private void billOpen(string strSeq)
{
TabStrip1.ActiveTabIndex = 1;
String prefix = ApiClientUtil.GetConfigCont("LICENSE_PATH");
gridPic.DataSource = getPicData(strSeq);
gridPic.DataBind();
DataTable mydt = gridPic_path1(strSeq);
if (mydt.Rows.Count > 0)
{
imgBMPPATH.ImageUrl = prefix + mydt.Rows[0]["PICPATH"].ToString().Replace("~", "");
}
else
{
Alert.Show("不要频繁点击，稍后片刻！");
}
}
/// <summary>
/// 处理分页拼接数据
/// </summary>
/// <param name="Billno">单据编号</param>
/// <param name="strWhere">筛选条件</param>
/// <param name="TableName">处理数据单据体</param>
/// <param name="pageIndex">分页</param>
/// <param name="pageSize">当前分页数</param>
/// <param name="newDict">新增数据</param>
public static bool PageInsert(string Billno, string strWhere, string TableName, int pageIndex, int pageSize, List <Dictionary <string, object> > newDict)
{
string connectionString = "";
if (strWhere.Length < 1)
{
strWhere = " 1=1";
}
else
{
strWhere = strGdseq(TableName, Billno, strWhere);
}
DataTable Res = new DataTable();
if (pageIndex > 1)
{
string strSql = string.Format("SELECT ERP.*,ROWNUM ERPNO FROM {0} ERP WHERE ERP.SEQNO = '{1}' AND ROWNUM <= ({2} - 1)*{3} AND {4}", TableName, Billno, pageIndex, pageSize, strWhere);
Res = DbHelperOra.Query(strSql).Tables[0];
}
else
{
Res = DbHelperOra.Query(string.Format("SELECT ERP.*,ROWNUM ERPNO FROM {0} ERP WHERE 1=2", TableName)).Tables[0];
}
for (int i = 0; i < newDict.Count; i++)
{
DataRow newrow = Res.NewRow();
newrow["ERPNO"] = Res.Rows.Count + 1;
newrow["SEQNO"] = Billno;
foreach (DataColumn dtcol in Res.Columns)
{
try
{
if (newDict[0].ContainsKey(dtcol.ToString()))
{
if (newDict[i][dtcol.ToString()] == null || string.IsNullOrWhiteSpace(newDict[i][dtcol.ToString()].ToString()))
{
newrow[dtcol] = DBNull.Value;
}
else
{
newrow[dtcol] = newDict[i][dtcol.ToString()];
}
}
}
catch
{ }
}
Res.Rows.Add(newrow);
}
//第二部分数据
string strSql2 = string.Format("SELECT * FROM (SELECT ERP.*,ROWNO ERPNO FROM {0} ERP WHERE SEQNO = '{1}' AND {4}) WHERE ERPNO > ({2} + 1)*{3}", TableName, Billno, pageIndex, pageSize, strWhere);
DataTable dt2 = DbHelperOra.Query(strSql2).Tables[0];
foreach (DataRow dr in dt2.Rows)
{
dr["ERPNO"] = Res.Rows.Count + 1;
Res.Rows.Add(dr.ItemArray);
}
//第三部分数据
string strSql3 = string.Format("SELECT ERP.*,ROWNO ERPNO FROM {0} ERP WHERE SEQNO = '{1}' AND NOT EXISTS (SELECT 1 FROM {0} WHERE SEQNO = ERP.SEQNO AND ROWNO = ERP.ROWNO AND {4})", TableName, Billno, pageIndex, pageSize, strWhere);
DataTable dt3 = DbHelperOra.Query(strSql3).Tables[0];
foreach (DataRow dr in dt3.Rows)
{
dr["ERPNO"] = Res.Rows.Count + 1;
Res.Rows.Add(dr.ItemArray);
}
try
{
Res.Columns.Remove("ROWNO");
Res.Columns["ERPNO"].ColumnName = "ROWNO";
}
catch
{
Res.Columns.Remove("ERPNO");
}
List <CommandInfo> cmdList = new List <CommandInfo>();
cmdList.Add(new CommandInfo(string.Format("DELETE {0} WHERE SEQNO='{1}'", TableName, Billno), null));
//cmdList.Add(new CommandInfo(string.Format("DELETE {0} WHERE SEQNO='{1}'", TableName.Substring(0, TableName.Length - 3) + "DOC", Billno), null));
DbHelperOra.ExecuteSqlTran(cmdList);
if (ConfigurationManager.ConnectionStrings["OracleConnString"] != null)
{
connectionString = ConfigurationManager.ConnectionStrings["OracleConnString"].ConnectionString;
}
else
{
throw new Exception(string.Format("从配置文件webconfig中找不到 {0} 的链接字符串配置项!", "OracleConnString"));
}
if (Res.Rows.Count < 1)
{
return(false);
}
#region Oracle.ManagedDataAccess.dll没有bulk方法,替换掉
//using (OracleConnection connection = new OracleConnection(connectionString))
//{
// using (OracleBulkCopy orabulkcopy = new OracleBulkCopy(connectionString, OracleBulkCopyOptions.UseInternalTransaction))
// {
// try
// {
// orabulkcopy.DestinationTableName = TableName;
// for (int i = 0; i < Res.Columns.Count; i++)
// {
// orabulkcopy.ColumnMappings.Add(Res.Columns[i].ColumnName, Res.Columns[i].ColumnName);
// }
// orabulkcopy.WriteToServer(Res);
// }
// catch (System.Exception ex)
// {
// return false;
// }
// }
//}
DataTable tableSchema = ApiClientUtil.GetTableSchema(TableName);
string columnNames = "";
string columnValues = "";
string sql = "";
StringBuilder builder = new StringBuilder();
builder.Append(" BEGIN ");
foreach (DataRow dr in Res.Rows)
{
columnNames = "";
columnValues = "";
foreach (DataColumn dc in tableSchema.Columns)
{
string colType = dc.DataType.ToString();
string colName = dc.ColumnName;
columnNames += colName + ",";
if (dr[colName] == null)
{
columnValues += "null,";
}
else if ("System.String".Equals(colType))
{
columnValues += "'" + dr[colName].ToString() + "',";
}
else if ("System.DateTime".Equals(colType))
{
columnValues += "TO_DATE('" + dr[colName].ToString() + "','mm/dd/yyyy hh24:mi:ss'),";
}
else if ("System.Decimal".Equals(colType))
{
if (!string.IsNullOrWhiteSpace(dr[colName].ToString()))
{
columnValues += dr[colName].ToString() + ",";
}
else
{
columnValues += 0 + ",";
}
}
else if ("System.Int32".Equals(colType))
{
if (!string.IsNullOrWhiteSpace(dr[colName].ToString()))
{
columnValues += dr[colName].ToString() + ",";
}
else
{
columnValues += 0 + ",";
}
}
else
{
columnValues += "'" + dr[colName].ToString() + "',";
}
}
sql = "INSERT INTO " + TableName + " (";
sql += columnNames.TrimEnd(',');
sql += ") VALUES (";
sql += columnValues.TrimEnd(',') + ");";
builder.Append(sql);
}
builder.Append(" END; ");
List <CommandInfo> cmdList2 = new List <CommandInfo>();
cmdList2.Add(new CommandInfo(builder.ToString(), null));
try
{
bool oraResult = DbHelperOra.ExecuteSqlTran(cmdList2);
if (!oraResult)
{
return(false);
}
}
catch
{
return(false);
}
#endregion
return(true);
}
/// <summary>
/// 批量数据插入
/// </summary>
/// <param name="connectionString"></param>
/// <param name="TableName">Oracle里的表名</param>
/// <param name="dt">临时表（包含数据)表结构要和数据库表一致</param>
/// <returns></returns>
public static string ExecuteSqlTranWithSqlBulkCopy(string connectionString, string TableName, DataTable dt, string[] Columns)
{
#region Oracle.ManagedDataAccess.dll没有bulk方法,替换掉
//增加数据验证
//using (OracleConnection connection = new OracleConnection(connectionString))
//{
// using (OracleBulkCopy orabulkcopy = new OracleBulkCopy(connectionString, OracleBulkCopyOptions.UseInternalTransaction))
// {
// try
// {
// orabulkcopy.DestinationTableName = TableName;
// for (int i = 0; i < dt.Columns.Count; i++)
// {
// orabulkcopy.ColumnMappings.Add(dt.Columns[i].ColumnName, dt.Columns[i].ColumnName);
// }
// orabulkcopy.WriteToServer(dt);
// return "";
// }
// catch (System.Exception ex)
// {
// return "FALSE";
// }
// }
//}
#endregion
DataTable tableSchema = ApiClientUtil.GetTableSchema(TableName);
string columnNames = "";
string columnValues = "";
string sql = "";
StringBuilder builder = new StringBuilder();
builder.Append(" BEGIN ");
foreach (DataRow dr in dt.Rows)
{
columnNames = "";
columnValues = "";
foreach (DataColumn dc in tableSchema.Columns)
{
string colType = dc.DataType.ToString();
string colName = dc.ColumnName;
columnNames += colName + ",";
if (dr[colName] == null)
{
columnValues += "null,";
}
else if ("System.String".Equals(colType))
{
columnValues += "'" + dr[colName].ToString() + "',";
}
else if ("System.DateTime".Equals(colType))
{
columnValues += "TO_DATE('" + dr[colName].ToString() + "','mm/dd/yyyy hh24:mi:ss'),";
}
else if ("System.Decimal".Equals(colType))
{
columnValues += dr[colName].ToString() + ",";
}
else if ("System.Int32".Equals(colType))
{
columnValues += dr[colName].ToString() + ",";
}
else
{
columnValues += "'" + dr[colName].ToString() + "',";
}
}
sql = "INSERT INTO " + TableName + " (";
sql += columnNames.TrimEnd(',');
sql += ") VALUES (";
sql += columnValues.TrimEnd(',') + ");";
builder.Append(sql);
}
builder.Append(" END; ");
List <CommandInfo> cmdList = new List <CommandInfo>();
cmdList.Add(new CommandInfo(builder.ToString(), null));
try
{
bool oraResult = DbHelperOra.ExecuteSqlTran(cmdList);
if (oraResult)
{
return("");
}
else
{
return("FALSE");
}
}
catch
{
return("FALSE");
}
}
private void DataInit()
{
if (!ApiClientUtil.isNull(Request.QueryString["hideks"]))
{
if (Request.QueryString["hideks"].Equals("1"))
{
ManageKeshi.Hidden = true;
}
}
PubFunc.DdlDataGet("DDL_GOODS_TYPE", srhCATID0, ddlCATID0);
PubFunc.DdlDataGet("DDL_DOC_SUPPLIERNULL", trbSUPPLIER);
PubFunc.DdlDataGet("DDL_PRODUCER", trbPRODUCER);
PubFunc.DdlDataGet("DDL_UNIT", ddlUNIT, ddlUNIT_DABZ, ddlUNIT_ZHONGBZ);
PubFunc.DdlDataGet("DDL_GOODS_STATUS", ddlFLAG, srhFLAG);
//PubFunc.DdlDataGet(ddlCATID, "DDL_SYS_CATLAST");
string strSql = @"select code,'【'||code||'】'||name name,(class-1) TreeLevel,decode(islast,'Y',1,0) islast
from sys_category
ORDER BY code ";
List <CategoryTreeBean> myList = new List <CategoryTreeBean>();
DataTable categoryTreeTable = DbHelperOra.Query(strSql).Tables[0];
foreach (DataRow dr in categoryTreeTable.Rows)
{
myList.Add(new CategoryTreeBean(dr["code"].ToString(), dr["name"].ToString(), Convert.ToInt16(dr["TreeLevel"]), Convert.ToInt16(dr["islast"]) == 1));
}
// 绑定到下拉列表（启用模拟树功能）
ddlCATID.EnableSimulateTree = true;
ddlCATID.DataTextField = "Name";
ddlCATID.DataValueField = "Id";
ddlCATID.DataEnableSelectField = "EnableSelect";
ddlCATID.DataSimulateTreeLevelField = "Level";
ddlCATID.DataSource = myList;
ddlCATID.DataBind();
string Sql = @"select code,'【'||code||'】'||name name,(class-1) TreeLevel,decode(islast,'Y',1,0) islast
from SYS_CATUSER
ORDER BY code ";
List <CategoryTreeBean> mList = new List <CategoryTreeBean>();
DataTable TreeTable = DbHelperOra.Query(Sql).Tables[0];
foreach (DataRow dr in TreeTable.Rows)
{
mList.Add(new CategoryTreeBean(dr["code"].ToString(), dr["name"].ToString(), Convert.ToInt16(dr["TreeLevel"]), Convert.ToInt16(dr["islast"]) == 1));
}
// 绑定到下拉列表（启用模拟树功能）
ddlCATUSER.EnableSimulateTree = true;
ddlCATUSER.DataTextField = "Name";
ddlCATUSER.DataValueField = "Id";
ddlCATUSER.DataEnableSelectField = "EnableSelect";
ddlCATUSER.DataSimulateTreeLevelField = "Level";
ddlCATUSER.DataSource = mList;
ddlCATUSER.DataBind();
hfdIsNew.Text = "Y";
hfdConfig.Text = "";
dpkINRQ.SelectedDate = DateTime.Now;
ddlFLAG.SelectedValue = "N";
tbxBZHL.Text = "1";
ddlCATID0.SelectedValue = "2";
//ckbISFLAG7.Checked = true;
}
