/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="psv"></param>
private System.Data.DataTable ExecMarCheck(ParamsCheckMarNotBelongToMar psv)
{
System.Data.DataTable dt;
try
{
SqlConnection sqlConn = new SqlConnection();
SqlCommand sqlCmd = new SqlCommand();
sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings");
DBCallCommon.PrepareStoredProc(sqlConn, sqlCmd, "PRO_TM_CheckMarNotBelongToMarBOM");
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@StrTable", psv.StrTabeleName, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@ENG_ID", psv.TaskID, SqlDbType.Text, 1000);
sqlConn.Open();
dt = DBCallCommon.GetDataTableUsingCmd(sqlCmd);
sqlConn.Close();
}
catch (Exception)
{
throw;
}
return(dt);
//SqlParameter[] pms = new SqlParameter[] {
//new SqlParameter("@StrTable",psv.StrTabeleName),
//new SqlParameter("@ENG_ID",psv.TaskID)
//}
//return SqlHelper.ExecuteDataTable("PRO_TM_CheckMarNotBelongToMarBOM", CommandType.StoredProcedure, pms);
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private string CheckMarNotBelongToMar()
{
string sql_delete = "delete from TBPM_TEMPORGDATA where BM_ENGID='" + ViewState["TaskID"].ToString() + "'";
DBCallCommon.ExeSqlText(sql_delete);//删除表TBPM_TEMPORGDATA中该生产制号下数据，防止意外情况未清空上次记录
string[] a = ViewState["TaskID"].ToString().Split('-');
string firstCharofZX = "1";
string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "\\.0\\.([1-9]{1}[0-9]{0,}){1}" + "|" + firstCharofZX + "(\\.[1-9]{1}[0-9]*)*)$";
string pattern2 = @"^" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}$";
Regex rgx = new Regex(pattern);
Regex rgx2 = new Regex(pattern2);
string ret = "0";
List <string> list_sql = new List <string>();
//检验序号格式
int startindex;
if (ViewState["MarFlag"].ToString() == "1")
{
startindex = 0;
}
else
{
startindex = 1;
}
for (int i = startindex; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
string xuhao = ((TextBox)gRow.FindControl("txtXuHao")).Text.Trim();
if (xuhao != "")
{
string mar = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
if (!rgx.IsMatch(xuhao))
{
ret = "FormError-" + firstCharofZX + "-" + xuhao;
return(ret);
}
else
{
list_sql.Add("insert into TBPM_TEMPORGDATA(BM_ZONGXU,BM_MARID,BM_ENGID) Values('" + xuhao + "','" + mar + "','" + ViewState["TaskID"].ToString() + "')");
}
}
else
{
return("EmptyXuhao");
}
}
//检验总序输入临时表
DBCallCommon.ExecuteTrans(list_sql);
//检验归属关系
ParamsCheckMarNotBelongToMar pcmar = new ParamsCheckMarNotBelongToMar();
pcmar.StrTabeleName = ViewState["tablename"].ToString();
pcmar.TaskID = ViewState["TaskID"].ToString();
System.Data.DataTable dt = this.ExecMarCheck(pcmar);
ret = dt.Rows[0][0].ToString();
return(ret);
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private string CheckMarNotBelongToMar()
{
string sql_delete = "delete from TBPM_TEMPORGDATA where BM_ENGID='" + tsaid.Text + "'";
DBCallCommon.ExeSqlText(sql_delete);//删除表TBPM_TEMPORGDATA中该生产制号下数据，防止意外情况未清空上次记录
string[] a = tsaid.Text.Split('-');
///////////////////////string firstCharofZX = a[a.Length - 1];
string firstCharofZX = "1";
string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "(\\.[1-9]{1}[0-9]*)*)$";
/////////////////////////////////string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}(\\.[1-9]{1}[0-9]*)*)$";
string pattern2 = @"^" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}$";
Regex rgx = new Regex(pattern);
Regex rgx2 = new Regex(pattern2);
string ret = "0";
List <string> list_sql = new List <string>();
//检验总序格式
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
zongxu = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
if (zongxu != "")
{
if (!rgx.IsMatch(zongxu))
{
ret = "FormError-" + firstCharofZX + "-" + zongxu;
return(ret);
}
else
{
string mar = "NotConcern";//由于批量复制是只是物料，这里不考虑物料为空的情况
if (mar != "")
{
list_sql.Add("insert into TBPM_TEMPORGDATA(BM_ZONGXU,BM_MARID,BM_ENGID) Values('" + zongxu + "','" + mar + "','" + tsaid.Text.Trim() + "')");
}
}
}
}
//检验总序输入临时表
DBCallCommon.ExecuteTrans(list_sql);
//检验归属关系
ParamsCheckMarNotBelongToMar pcmar = new ParamsCheckMarNotBelongToMar();
pcmar.StrTabeleName = ViewState["tablename"].ToString();
pcmar.TaskID = tsaid.Text;
DataTable dt = this.ExecMarCheck(pcmar);
ret = dt.Rows[0][0].ToString();
return(ret);
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="psv"></param>
private System.Data.DataTable ExecMarCheck(ParamsCheckMarNotBelongToMar psv)
{
System.Data.DataTable dt;
try
{
SqlConnection sqlConn = new SqlConnection();
SqlCommand sqlCmd = new SqlCommand();
sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings");
DBCallCommon.PrepareStoredProc(sqlConn, sqlCmd, "[PRO_TM_CheckMarNotBelongToMarMSBOM]");
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@StrTable", psv.StrTabeleName, SqlDbType.Text, 1000);
DBCallCommon.AddParameterToStoredProc(sqlCmd, "@ENG_ID", psv.TaskID, SqlDbType.Text, 1000);
sqlConn.Open();
dt = DBCallCommon.GetDataTableUsingCmd(sqlCmd);
sqlConn.Close();
}
catch (Exception)
{
throw;
}
return(dt);
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private string CheckMarNotBelongToMar()
{
string sql_delete = "delete from TBPM_TEMPORGDATA where BM_ENGID='" + tsaid.Text + "'";
DBCallCommon.ExeSqlText(sql_delete);//删除表TBPM_TEMPORGDATA中该生产制号下数据，防止意外情况未清空上次记录
///////////////////string firstCharofZX=a[a.Length-1];
///////////////////string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}(\\.[1-9]{1}[0-9]*)*)$";
string firstCharofZX = "1";
string pattern = @"^[1-9]{1,2}(\(\d\))?((\.[1-9]{1}\d*)(\(\d\))?)*$";
// string pattern2 = @"^" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}$";
Regex rgx = new Regex(pattern);
// Regex rgx2 = new Regex(pattern2);
string ret = "0";
List <string> list_sql = new List <string>();
//对于重复总序及序号的检查
ArrayList array_marid_zongxu_name = new ArrayList();
ArrayList array_xuhao = new ArrayList();
int index = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
string id = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
string zx = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
string mc = ((HtmlInputText)gRow.FindControl("ch_name")).Value.Trim();
// string txt_xuhao = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("txtXuhao")).Text.Trim();
//if (txt_xuhao != "")
//{
// array_xuhao.Add(txt_xuhao);
//}
if (zx != "")
{
array_marid_zongxu_name.Add(id + "," + zx);
index++;
}
}
if (index > 1)
{
for (int i = 0; i < array_marid_zongxu_name.Count - 1; i++)
{
for (int j = i + 1; j < array_marid_zongxu_name.Count; j++)
{
string zongxu_i = array_marid_zongxu_name[i].ToString().Split(',')[1];
string zongxu_j = array_marid_zongxu_name[j].ToString().Split(',')[1];
if (zongxu_i == zongxu_j)
{
string zx_0 = zongxu_i + ",0";
if (Arraylist_samezx.Count == 0)
{
Arraylist_samezx.Add(zx_0);
}
else
{
for (int m = 0; m < Arraylist_samezx.Count; m++)
{
if (Arraylist_samezx[m].ToString() == zx_0)
{
break;
}
else if (Arraylist_samezx[m].ToString() != zx_0 && m + 1 == Arraylist_samezx.Count)
{
Arraylist_samezx.Add(zx_0);
}
}
}
if (array_marid_zongxu_name[i].ToString() != array_marid_zongxu_name[j].ToString())
{
string[] aa = array_marid_zongxu_name[i].ToString().Split(',');
ret = "SameZongxu-" + aa[1];
return(ret);
}
}
}
}
}
//if (Arraylist_samezx.Count > 0)
//{
// this.CheckZeroXuHaoExist();
//}
//检验总序格式
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
zongxu = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
ch_name = ((HtmlInputText)gRow.FindControl("ch_name")).Value.Trim();
if (zongxu != "")
{
string mar = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
if (!rgx.IsMatch(zongxu))
{
ret = "FormError-" + firstCharofZX + "-" + zongxu;
return(ret);
}
else if (ch_name == "")
{
ret = "NameEmptyError-" + firstCharofZX + "-" + zongxu;
return(ret);
}
else
{
list_sql.Add("insert into TBPM_TEMPORGDATA(BM_ZONGXU,BM_MARID,BM_ENGID) Values('" + zongxu + "','" + mar + "','" + tsaid.Text.Trim() + "')");
}
}
}
//检验总序输入临时表
DBCallCommon.ExecuteTrans(list_sql);
//部件重复检验
sqlText = "select BM_ZONGXU from (select BM_ZONGXU,BM_MARID from TBPM_TEMPORGDATA where BM_ENGID='" + tsaid.Text.Trim() + "' union all select BM_ZONGXU,BM_MARID from TBPM_STRINFODQO where BM_ENGID='" + tsaid.Text.Trim() + "')a where BM_MARID='' group by BM_ZONGXU having count(*)>1";
System.Data.DataTable dt1 = DBCallCommon.GetDTUsingSqlText(sqlText);
if (dt1.Rows.Count > 0)
{
ret = "SameZongxuWithoutMaird-" + dt1.Rows[0][0];
return(ret);
}
//检验归属关系
ParamsCheckMarNotBelongToMar pcmar = new ParamsCheckMarNotBelongToMar();
pcmar.StrTabeleName = tablename;
pcmar.TaskID = tsaid.Text;
System.Data.DataTable dt = this.ExecMarCheck(pcmar);
ret = dt.Rows[0][0].ToString();
return(ret);
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private string CheckMarNotBelongToMar()
{
this.CheckjgMarId();
this.CheckwgMarId();
string sql_delete = "delete from TBPM_TEMPORGDATA where BM_ENGID='" + tsaid.Text + "'";
DBCallCommon.ExeSqlText(sql_delete);//删除表TBPM_TEMPORGDATA中该生产制号下数据，防止意外情况未清空上次记录
string [,] array_checkmarreapte = new string[200, 6];
int arryCapacity = 0;
// string[] a = tsaid.Text.Split('-');
//////////string firstCharofZX = a[a.Length - 1];
/////////string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}(\\.[1-9]{1}[0-9]*)*)$";
string firstCharofZX = "1";
string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "(\\.[1-9]{1}[0-9]*)*)$";
string pattern2 = @"^" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}$";
Regex rgx = new Regex(pattern);
Regex rgx2 = new Regex(pattern2);
string ret = "0";
List <string> list_sql = new List <string>();
//检验总序格式
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
//总序
zongxu = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
//类型
type = ((DropDownList)gRow.FindControl("ddltype")).SelectedValue;
//名称
ch_name = ((HtmlInputText)gRow.FindControl("ch_name")).Value.Trim();
//规格
guige = ((HtmlInputText)gRow.FindControl("guige")).Value.Trim();
//材质
caizhi = ((HtmlInputText)gRow.FindControl("caizhi")).Value.Trim();
//国标
biaozhun = ((HtmlInputText)gRow.FindControl("biaozhun")).Value.Trim();
//重量
string zh = ((HtmlInputText)gRow.FindControl("dzh")).Value.Trim();
if (zongxu != "" & type != "0")
{
if (!rgx.IsMatch(zongxu))
{
ret = "FormError-" + firstCharofZX + "-" + zongxu;
return(ret);
}
else if (zh == "" || zh == "0")
{
ret = "NoWeight-" + zongxu;
return(ret);
}
else
{
array_checkmarreapte[arryCapacity, 0] = ch_name;
array_checkmarreapte[arryCapacity, 1] = guige;
array_checkmarreapte[arryCapacity, 2] = caizhi;
array_checkmarreapte[arryCapacity, 3] = biaozhun;
array_checkmarreapte[arryCapacity, 4] = Convert.ToInt16(i + 1).ToString();
array_checkmarreapte[arryCapacity, 5] = type;
arryCapacity++;
list_sql.Add("insert into TBPM_TEMPORGDATA(BM_ZONGXU,BM_MARID,BM_ENGID) Values('" + zongxu + "','AllHaveMar','" + tsaid.Text.Trim() + "')");
}
}
}
//检验是否有重复的物料（页面上）
string retValue = this.CheckMarRepeat(array_checkmarreapte, arryCapacity);
if (retValue.Contains("True-"))
{
return(retValue);
}
//检验页面上将生成的物料与数据库中是否重复
string retDBValue = this.CheckMarReapteInDB(array_checkmarreapte, arryCapacity);
if (retDBValue.Contains("TrueMarDB-"))
{
return(retDBValue);
}
//检验总序输入临时表
DBCallCommon.ExecuteTrans(list_sql);
//检验归属关系
ParamsCheckMarNotBelongToMar pcmar = new ParamsCheckMarNotBelongToMar();
pcmar.StrTabeleName = "TBPM_STRINFODQO";
pcmar.TaskID = tsaid.Text;
if (ckbAdd.Checked)
{
pcmar.Child = "2";//可以录入归属物料
}
else
{
pcmar.Child = "1";//不能存在归属物料
}
System.Data.DataTable dt = this.ExecMarCheck(pcmar);
ret = dt.Rows[0][0].ToString();
return(ret);
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private string CheckMarNotBelongToMar()
{
string sql_delete = "delete from TBPM_TEMPORGDATA where BM_ENGID='" + tsaid.Text + "'";
DBCallCommon.ExeSqlText(sql_delete);//删除表TBPM_TEMPORGDATA中该生产制号下数据，防止意外情况未清空上次记录
string firstCharofZX = "1";
string pattern = @"^[1-9]{1,2}(\(\d\))?((\.[1-9]{1}\d*)(\(\d\))?)*$";
Regex rgx = new Regex(pattern);
// Regex rgx2 = new Regex(pattern2);
string ret = "0";
List <string> list_sql = new List <string>();
//对于重复总序的检查
ArrayList array_marid_zongxu_name = new ArrayList();
ArrayList array_xuhao = new ArrayList();
int index = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
string id = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
string zx = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
string mc = ((HtmlInputText)gRow.FindControl("ch_name")).Value.Trim();
if (zx != "")
{
array_marid_zongxu_name.Add(id + "," + zx);
index++;
}
}
if (index > 1)
{
for (int i = 0; i < array_marid_zongxu_name.Count - 1; i++)
{
for (int j = i + 1; j < array_marid_zongxu_name.Count; j++)
{
string zongxu_i = array_marid_zongxu_name[i].ToString().Split(',')[1];
string zongxu_j = array_marid_zongxu_name[j].ToString().Split(',')[1];
if (zongxu_i == zongxu_j)
{
ret = "SameZongxu-" + zongxu_i;
}
}
}
}
//检验总序格式
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
zongxu = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
if (zongxu != "")
{
string mar = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
if (!rgx.IsMatch(zongxu))
{
ret = "FormError-" + firstCharofZX + "-" + zongxu;
return(ret);
}
else
{
list_sql.Add("insert into TBPM_TEMPORGDATA(BM_ZONGXU,BM_MARID,BM_ENGID) Values('" + zongxu + "','" + mar + "','" + tsaid.Text.Trim() + "')");
}
}
}
//检验总序修改只能在规定范围内
for (int i = 0; i < GridView1.Rows.Count; i++)
{
if (zongxu != "")
{
GridViewRow gRow = GridView1.Rows[i];
zongxu = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
if (!zongxu.Contains(EditZongXu))
{
ret = "OverFather-";
return(ret);
}
}
}
//检验归属关系
ParamsCheckMarNotBelongToMar pcmar = new ParamsCheckMarNotBelongToMar();
pcmar.StrTabeleName = tablename;
pcmar.TaskID = tsaid.Text;
System.Data.DataTable dt = this.ExecMarCheck(pcmar);
ret = dt.Rows[0][0].ToString();
return(ret);
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private string CheckMarNotBelongToMar()
{
string sql_delete = "delete from TBPM_TEMPORGDATA where BM_ENGID='" + tsaid.Text + "'";
DBCallCommon.ExeSqlText(sql_delete);//删除表TBPM_TEMPORGDATA中该生产制号下数据，防止意外情况未清空上次记录
string[] a = tsaid.Text.Split('-');
///////////////////string firstCharofZX=a[a.Length-1];
///////////////////string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}|" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}(\\.[1-9]{1}[0-9]*)*)$";
string firstCharofZX = "1";
string pattern = @"^(" + firstCharofZX + "|" + firstCharofZX + "(\\.[1-9]{1}[0-9]*)*)$";
string pattern2 = @"^" + firstCharofZX + "\\.[1-9]{1}[0-9]{0,1}$";
Regex rgx = new Regex(pattern);
Regex rgx2 = new Regex(pattern2);
string ret = "0";
List <string> list_sql = new List <string>();
//对于重复总序及序号的检查
ArrayList array_marid_zongxu_name = new ArrayList();
ArrayList array_xuhao = new ArrayList();
int index = 0;
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
string id = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
string zx = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
string mc = ((HtmlInputText)gRow.FindControl("ch_name")).Value.Trim();
string xh = ((HtmlInputText)gRow.FindControl("txtXuhao")).Value.Trim();
if (zx != "" && xh != "")
{
array_marid_zongxu_name.Add(id + "," + zx);
index++;
}
if (xh != "")
{
array_xuhao.Add(xh);
}
if (zx != "")//数据库中是否存在该总序
{
string sql_zx = "select count(BM_ZONGXU) from " + tablename + " where BM_ENGID LIKE '" + tsaid.Text.Trim().Split('-')[0] + "-%' AND BM_ZONGXU='" + zx + "' AND BM_MARID!='" + id + "'";
if (DBCallCommon.GetDTUsingSqlText(sql_zx).Rows[0][0].ToString() != "0")
{
return("总序在数据库中已存在-" + zx);
}
}
}
if (index > 1)
{
for (int i = 0; i < array_marid_zongxu_name.Count - 1; i++)
{
for (int j = i + 1; j < array_marid_zongxu_name.Count; j++)
{
string zongxu_i = array_marid_zongxu_name[i].ToString().Split(',')[1];
string zongxu_j = array_marid_zongxu_name[j].ToString().Split(',')[1];
if (zongxu_i == zongxu_j)
{
string zx_0 = zongxu_i + ",0";
if (Arraylist_samezx.Count == 0)
{
Arraylist_samezx.Add(zx_0);
}
else
{
for (int m = 0; m < Arraylist_samezx.Count; m++)
{
if (Arraylist_samezx[m].ToString() == zx_0)
{
break;
}
else if (Arraylist_samezx[m].ToString() != zx_0 && m + 1 == Arraylist_samezx.Count)
{
Arraylist_samezx.Add(zx_0);
}
}
}
if (array_marid_zongxu_name[i].ToString() != array_marid_zongxu_name[j].ToString())
{
string[] aa = array_marid_zongxu_name[i].ToString().Split(',');
ret = "SameZongxu-" + aa[1];
return(ret);
}
}
}
}
}
//检验总序、序号格式
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gRow = GridView1.Rows[i];
zongxu = ((HtmlInputText)gRow.FindControl("zongxu")).Value.Trim();
xuhao = ((HtmlInputText)gRow.FindControl("txtXuhao")).Value.Trim();
if (zongxu != "")
{
string mar = ((System.Web.UI.WebControls.TextBox)gRow.FindControl("marid")).Text.Trim();
if (!rgx.IsMatch(zongxu))
{
ret = "FormError-" + firstCharofZX + "-" + zongxu;
return(ret);
}
else if (!rgx.IsMatch(xuhao))
{
ret = "FormError-" + firstCharofZX + "-" + xuhao;
return(ret);
}
else
{
list_sql.Add("insert into TBPM_TEMPORGDATA(BM_ZONGXU,BM_MARID,BM_ENGID) Values('" + xuhao + "','" + mar + "','" + tsaid.Text.Trim() + "')");
}
}
}
//序号格式验证（1、与数据库中是否重复；2、与页面上序号是否重复；3、页面上序号是否重复）
#region
int j_index_xuhao = array_xuhao.Count;
int i_index_xuhao = j_index_xuhao - 1;
for (int i = 0; i < i_index_xuhao; i++)
{
//数据库中序号是否存在
string sql = "select * from " + tablename + " where BM_ENGID LIKE '" + tsaid.Text.Trim().Split('-')[0] + "-%' AND BM_XUHAO='" + array_xuhao[i] + "'";
SqlDataReader dr_sql = DBCallCommon.GetDRUsingSqlText(sql);
if (dr_sql.HasRows)
{
dr_sql.Close();
return("序号已存在-" + array_xuhao[i]);
}
else
{
//页面上序号是否重复
for (int j = i + 1; j < j_index_xuhao; j++)
{
if (array_xuhao[i].ToString() == array_xuhao[j].ToString())
{
ret = "页面上序号重复-" + array_xuhao[i].ToString();
return(ret);
}
}
}
}
if (array_xuhao.Count > 0)
{
//数据库中序号是否存在
string sql = "select * from " + tablename + " where BM_ENGID LIKE '" + tsaid.Text.Trim().Split('-')[0] + "-%' AND BM_XUHAO='" + array_xuhao[array_xuhao.Count - 1] + "'";
SqlDataReader dr_sql = DBCallCommon.GetDRUsingSqlText(sql);
if (dr_sql.HasRows)
{
dr_sql.Close();
return("序号已存在-" + array_xuhao[array_xuhao.Count - 1]);
}
}
#endregion
//检验总序输入临时表
DBCallCommon.ExecuteTrans(list_sql);
//检验归属关系
ParamsCheckMarNotBelongToMar pcmar = new ParamsCheckMarNotBelongToMar();
this.GetListName();
pcmar.StrTabeleName = tablename;
pcmar.TaskID = tsaid.Text;
System.Data.DataTable dt = this.ExecMarCheck(pcmar);
ret = dt.Rows[0][0].ToString();
return(ret);
}
