/// <summary>
/// 计量单位验证
/// </summary>
/// <param name="value"></param>
/// <param name="str"></param>
/// <param name="index"></param>
/// <param name="Tran"></param>
/// <returns></returns>
public string CheckGoodsUnit(string value, string str, SqlTransaction Tran)
{
List <Hi.Model.BD_DefDoc_B> l = new Hi.BLL.BD_DefDoc_B().GetList("", " AtVal = '" + value.Trim() + "' and AtName='计量单位' and compid=" + this.CompID + " and isnull(dr,0)=0", "", Tran);
if (l.Count == 0)
{
List <Hi.Model.BD_DefDoc> list = new Hi.BLL.BD_DefDoc().GetList("", " AtName='计量单位' and compid=" + this.CompID + " and isnull(dr,0)=0", "", Tran);
int defid = 0;
if (list.Count == 0)
{
Hi.Model.BD_DefDoc doc = new Hi.Model.BD_DefDoc();
doc.CompID = this.CompID;
doc.AtCode = "";
doc.AtName = "计量单位";
doc.ts = DateTime.Now;
doc.modifyuser = this.UserID;
doc.dr = 0;
defid = new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
else
{
defid = list[0].ID;
}
Hi.Model.BD_DefDoc_B item = new Hi.Model.BD_DefDoc_B();
item.AtVal = value;
item.AtName = "计量单位";
item.CompID = this.CompID;
item.DefID = defid;
item.ts = DateTime.Now;
item.dr = 0;
item.modifyuser = this.UserID;
int count = new Hi.BLL.BD_DefDoc_B().Add(item, Tran);
//if (count == 0)
//{
// JScript.AlertMethod(this, "Excel没有数据，请重新导入", JScript.IconOption.错误, "function(){location.href='ImportGoods.aspx'}");
// throw new ApplicationException("Excel行号为： <i error>" + (index + TitleIndex + 1) + "</i> 的数据有误。" + str + "录入数据库失败，请修改后重新导入。");
//}
}
return(value);
}
/// <summary>
/// 添加费用科目
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected string AddFykm(string unit)
{
SqlTransaction Tran = null;
try
{
Tran = DBUtility.SqlHelper.CreateStoreTranSaction();
//新增数据字典
Hi.Model.BD_DefDoc doc = new Hi.Model.BD_DefDoc();
doc.CompID = this.CompID;
doc.AtCode = "";
doc.AtName = "费用科目";
doc.ts = DateTime.Now;
doc.modifyuser = UserID;
doc.dr = 0;
List <Hi.Model.BD_DefDoc> ll = new Hi.BLL.BD_DefDoc().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and atname='费用科目'", "");
int defid = 0;
if (ll.Count == 0)
{
defid = new Hi.BLL.BD_DefDoc().Add(doc, Tran);
}
else
{
defid = ll[0].ID;
}
if (defid != 0)
{
Hi.Model.BD_DefDoc_B doc2 = new Hi.Model.BD_DefDoc_B();
doc2.CompID = this.CompID;
doc2.DefID = defid;
doc2.AtName = "费用科目";
doc2.AtVal = unit; //txtunits.Value.Trim();
doc2.ts = DateTime.Now;
doc2.dr = 0;
doc2.modifyuser = this.UserID;
List <Hi.Model.BD_DefDoc_B> lll = new Hi.BLL.BD_DefDoc_B().GetList("", "isnull(dr,0)=0 and compid=" + this.CompID + " and atname='费用科目' and defid=" + defid + " and atval='" + unit + "'", "");
if (lll.Count == 0)
{
new Hi.BLL.BD_DefDoc_B().Add(doc2, Tran);
}
else
{
return("[{\"AtVal\":\"ycz\"}]");
}
}
Tran.Commit();
List <Hi.Model.BD_DefDoc> l = new Hi.BLL.BD_DefDoc().GetList("", "AtName='费用科目' and compid=" + this.CompID + " and isnull(dr,0)=0", "");
if (l.Count > 0)
{
List <Hi.Model.BD_DefDoc_B> llll = new Hi.BLL.BD_DefDoc_B().GetList("", "DefID=" + l[0].ID + "and ISNULL(dr,0)=0 and compid=" + this.CompID, "id desc");
if (llll.Count > 0)
{
DataTable dt = Common.FillDataTable(llll);
if (dt.Rows.Count != 0)
{
return(ConvertJson.ToJson(dt));
}
}
}
return("[{\"AtVal\":\"cc\"}]");
// this.txtunit.Value = unit;
}
catch (Exception)
{
if (Tran != null)
{
if (Tran.Connection != null)
{
Tran.Rollback();
}
}
return("[{\"AtVal\":\"sb\"}]");
}
finally
{
DBUtility.SqlHelper.ConnectionClose();
}
}