/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(id,'') from rdrecord01 with(nolock) where ccode='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(ccode,'') from rdrecord01 with(nolock) where id='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
BLL.Common.ErrorMsg(ret, "未能获采购入库单ID或单号");
return(ret);
}
/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(WorkHrId,'') from Sfc_workhrnote with(nolock) where " + sourceVoucherNoColumnName + " ='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(" + sourceVoucherNoColumnName + ",'') from Sfc_workhrnote with(nolock) where WorkHrId ='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
BLL.Common.ErrorMsg(ret, "未能获取" + voucherTypeName + "ID或单号");
return(ret);
}
/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(id,'') from PU_ArrivalVouch with(nolock) where " + targetVoucherNoColumnName + "='" + strID + "'";
}
if (codeorid == "code")
{
sqlstr = "select isnull(" + targetVoucherNoColumnName + ",'') from PU_ArrivalVouch with(nolock) where id ='" + strID + "'";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
ApiService.BLL.Common.ErrorMsg(ret, "未能获采购退货单ID或单号");
return(ret);
}
/// <summary>
/// ID CODE 互查
/// </summary>
/// <param name="strID"></param>
/// <param name="bd"></param>
/// <param name="codeorid"></param>
/// <returns></returns>
public override string GetCodeorID(string strID, BaseData bd, string codeorid)
{
string sqlstr = string.Empty;
if (codeorid == "id")
{
sqlstr = "select isnull(dlid,'') from DispatchList with(nolock) where cdlcode ='" + strID + "' and cvouchtype = '05' ";
}
if (codeorid == "code")
{
sqlstr = "select isnull(cdlcode,'') from DispatchList with(nolock) where dlid ='" + strID + "' and cvouchtype = '05' ";
}
Model.APIData apidata = bd as Model.APIData;
DBUtility.DbHelperSQLP sqlp = new DBUtility.DbHelperSQLP(apidata.ConnectInfo.Constring);
string ret = sqlp.GetSingle(sqlstr).NullToString();
ApiService.BLL.Common.ErrorMsg(ret, "未能获销售退货单ID或单号");
return(ret);
}