public string CheckCustomer(string custNo)
{
try
{
DataSet dsCustDetail = customerDetails.GetDataToDateset("CustomerMaster (NOLOCK)", "pCustMstrID,fBillToNo,CustCd,CustNo", "CustNo='" + custNo + "' or CustSearchKey='" + custNo + "'");
Session["CustometDetail"] = dsCustDetail;
if (dsCustDetail != null && dsCustDetail.Tables[0].Rows.Count > 0)
{
DataTable dtLock = customerDetails.CustomerLock("Lock", dsCustDetail.Tables[0].Rows[0][0].ToString().Trim());
if (dtLock != null && dtLock.Rows.Count > 0)
{
return(dtLock.Rows[0][0].ToString().Trim() + "~" + dtLock.Rows[0][1].ToString().Trim() + "~" + custNo);
}
else
{
return("");
}
}
else
{
return("");
}
}
catch (Exception ex) { return(""); }
}
