public static bool InsertProviderInfo(ProviderInfoModel model, out string ID)
{
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERINFO_ADD;
succ = ProviderInfoDBHelper.InsertProviderInfo(model, out ID);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改时绑定信息
/// </summary>
/// <param name="id"></param>
private void BindInfo(int id)
{
RequiredFieldValidator1.Visible = false;
txtnumber.Visible = false;
lblNumber.Visible = true;
lblInfo.Visible = false;
ViewState["id"] = id;
ProviderInfoModel provider = new ProviderInfoModel();
provider = ProviderManageBLL.GetProviderInfoById(id);
txtAddress.Text = provider.Address;
txtBankAddress.Text = provider.BankAddress;
if (provider.BankName.ToString() != "")
{
this.ddlCountry.SelectedValue = ProviderManageBLL.GetCountryByBank(provider.BankName);
}
ddlCountry_SelectedIndexChanged(null, null);
ddlBankName.SelectedValue = provider.BankName;
txtBankNumber.Text = provider.BankNumber;
txtDutyNumber.Text = provider.DutyNumber;
txtEmail.Text = provider.Email;
txtFax.Text = provider.Fax;
txtForShort.Text = provider.ForShort;
txtLinkMan.Text = provider.LinkMan;
txtMobile.Text = provider.Mobile;
txtName.Text = provider.Name;
lblNumber.Text = provider.Number;
txtRemark.Text = provider.Remark;
txtTelephone.Text = provider.Telephone;
txtUrl.Text = provider.Url;
}
//public static bool UpdateProviderInfo(ProviderInfoModel model, string no)
public static bool UpdateProviderInfo(ProviderInfoModel model)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (model.ID <= 0)
{
return(false);
}
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.CustNo);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_PROVIDERINFO_ADD;
succ = ProviderInfoDBHelper.UpdateProviderInfo(model);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
protected void ddlProvider_SelectedIndexChanged(object sender, EventArgs e)
{
ProviderInfoModel provider = new ProviderInfoModel();
provider = ProviderManageBLL.GetProviderInfoById(Convert.ToInt32(ddlProvider.SelectedValue));
txtAddress.Text = provider.Address;
}
/// <summary>
/// Update the provider information by ID ---DS2012
/// </summary>
/// <param name="provider">ProviderInfo model</param>
/// <returns>Return affected rows which update the provider information by ID</returns>
public static int UpdateProviderInfo(ProviderInfoModel provider)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@ID", provider.ID),
new SqlParameter("@Number", provider.Number),
new SqlParameter("@Name", provider.Name),
new SqlParameter("@ForShort", provider.ForShort),
new SqlParameter("@LinkMan", provider.LinkMan),
new SqlParameter("@Mobile", provider.Mobile),
new SqlParameter("@Telephone", provider.Telephone),
new SqlParameter("@Fax", provider.Fax),
new SqlParameter("@Url", provider.Url),
new SqlParameter("@Email", provider.Email),
new SqlParameter("@Address", provider.Address),
new SqlParameter("@BankAddress", provider.BankAddress),
new SqlParameter("@BankName", provider.BankName),
new SqlParameter("@BankNumber", provider.BankNumber),
new SqlParameter("@DutyNumber", provider.DutyNumber),
new SqlParameter("@Remark", provider.Remark),
new SqlParameter("@Status", provider.Status),
new SqlParameter("@PermissionMan", provider.PermissionMan),
new SqlParameter("@OperateIP", provider.OperateIP),
new SqlParameter("@OperateNum", provider.OperateNum)
};
return(DBHelper.ExecuteNonQuery("UpdatePrividerInfo", param, CommandType.StoredProcedure));
}
/// <summary>
/// 查询全部的供应商信息
/// </summary>
/// <param name="pageindex"></param>
/// <param name="pagesize"></param>
/// <param name="RecordCount"></param>
/// <param name="PageCount"></param>
/// <returns></returns>
public static IList <ProviderInfoModel> GetProviderInfoAll(int pageindex, int pagesize, out int RecordCount, out int PageCount)
{
string conuls = "ID, Number, Name, ForShort, LinkMan, Mobile, Telephone, Fax, Email, Url, Address, BankName, BankAddress, BankNumber, DutyNumber, Remark, Status, PermissionMan, OperateIP, OperateNum";
DataTable table = CommonDataDAL.GetDataTablePage_Sms(pageindex, pagesize, "ProviderInfo", conuls, "", "ID", out RecordCount, out PageCount);
IList <ProviderInfoModel> list = new List <ProviderInfoModel>();
foreach (DataRow row in table.Rows)
{
ProviderInfoModel pro = new ProviderInfoModel();
pro.Address = row["Address"].ToString();
pro.BankAddress = row["BankAddress"].ToString();
pro.BankName = row["BankName"].ToString();
pro.BankNumber = row["BankNumber"].ToString();
pro.DutyNumber = row["DutyNumber"].ToString();
pro.Email = row["Email"].ToString();
pro.Fax = row["Fax"].ToString();
pro.ForShort = row["ForShort"].ToString();
//pro.ID = Convert.ToInt32(row["ID"]);
pro.LinkMan = row["LinkMan"].ToString();
pro.Mobile = row["Mobile"].ToString();
pro.Name = row["Name"].ToString();
pro.Number = row["Number"].ToString();
pro.OperateIP = row["OperateIP"].ToString();
pro.OperateNum = row["OperateNum"].ToString();
pro.PermissionMan = row["PermissionMan"].ToString();
pro.Remark = row["Remark"].ToString();
pro.Status = Convert.ToInt32(row["Status"]);
pro.Telephone = row["Telephone"].ToString();
pro.Url = row["Url"].ToString();
list.Add(pro);
}
return(list);
}
/// <summary>
/// 根据id查询供应商 ---DS2012
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ProviderInfoModel GetProviderInfoById(int id)
{
SqlDataReader row = DBHelper.ExecuteReader("GetProviderInfoByID", new SqlParameter("@id", id), CommandType.StoredProcedure);
ProviderInfoModel pro = new ProviderInfoModel();
while (row.Read())
{
pro.Address = row["Address"].ToString();
pro.BankAddress = row["BankAddress"].ToString();
pro.BankName = row["BankName"].ToString();
pro.BankNumber = row["BankNumber"].ToString();
pro.DutyNumber = row["DutyNumber"].ToString();
pro.Email = row["Email"].ToString();
pro.Fax = row["Fax"].ToString();
pro.ForShort = row["ForShort"].ToString();
pro.ID = Convert.ToInt32(row["ID"]);
pro.LinkMan = row["LinkMan"].ToString();
pro.Mobile = row["Mobile"].ToString();
pro.Name = row["Name"].ToString();
pro.Number = row["Number"].ToString();
pro.OperateIP = row["OperateIP"].ToString();
pro.OperateNum = row["OperateNum"].ToString();
pro.PermissionMan = row["PermissionMan"].ToString();
pro.Remark = row["Remark"].ToString();
pro.Status = Convert.ToInt32(row["Status"]);
pro.Telephone = row["Telephone"].ToString();
pro.Url = row["Url"].ToString();
}
row.Close();
return(pro);
}
public void ProviderUpsert()
{
List <ProviderInfoModel> ListCustomerProviderInfo = new List <ProviderInfoModel>();
ProviderInfoModel CustomerProviderInfo = new ProviderInfoModel();
CustomerProviderInfo.ProviderInfoType = new CatalogModel()
{
ItemId = 401
};
CustomerProviderInfo.Value = "201";
ListCustomerProviderInfo.Add(CustomerProviderInfo);
//Create Provider
ProviderModel ProviderToCreate = new ProviderModel()
{
CustomerPublicId = "1C17DDCD",
Name = "ProveedorTest",
IdentificationType = new Provider.Models.Util.CatalogModel()
{
ItemId = 101
},
IdentificationNumber = "00002",
Email = "*****@*****.**",
RelatedProviderCustomerInfo = ListCustomerProviderInfo
};
string result = DocumentManagement.Provider.Controller.Provider.ProviderUpsert(ProviderToCreate);
//Assert.IsNotNull(result);
}
public static DataTable GetProviderInfo(ProviderInfoModel ProviderInfoM, int pageIndex, int pageCount, string OrderBy, out int totalCount)
{
try
{
return(ProviderInfoDBHelper.GetProviderInfo(ProviderInfoM, pageIndex, pageCount, OrderBy, out totalCount));
}
catch (Exception ex)
{
throw ex;
}
}
public int Add(ProviderInfoModel model, string bs)
{
string str = "";
if (bs == "0")
{
str = FormsAuthentication.HashPasswordForStoringInConfigFile(this.SysPwd, "md5");
}
if (bs == "1")
{
str = FormsAuthentication.HashPasswordForStoringInConfigFile(model.PassWord, "md5");
}
int num = int.Parse(publicDbOpClass.QuaryMaxid("pm_provider_info", "ProviderId")) + 1;
StringBuilder builder = new StringBuilder();
builder.Append("insert into pm_provider_info(");
builder.Append("ProviderId,ClassId,ProviderName,ProviderICode,State,ServiceArea,Address,Contacter,Telphon,Mobile,WebStie,[E-mail],PriceRange,Comment,UserName,PassWord,UserCode,RecordDate,ProduceDimensions,TradeStatus,MarketDispositionf,BusinessStanding,CraftworkEquip,ProductQuality,ManufacturingCapacity,Equip,Manpower,OutstandingAchievement,ServiceEnsure,MarketingStrategy");
builder.Append(")");
builder.Append(" values (");
builder.Append(num.ToString() + ",");
builder.Append(model.ClassId.ToString() + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.ProviderName.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.ProviderICode.Trim()) + ",");
builder.Append("'" + model.State + "',");
builder.Append(SqlStringConstructor.GetQuotedString(model.ServiceArea.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Address.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Contacter.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Telphon.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Mobile.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.WebStie.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Email.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.PriceRange.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.Comment.Trim()) + ",");
builder.Append(SqlStringConstructor.GetQuotedString(model.UserName.Trim()) + ",");
builder.Append("'" + str + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.ProduceDimensions + "',");
builder.Append("'" + model.TradeStatus + "',");
builder.Append("'" + model.MarketDispositionf + "',");
builder.Append("'" + model.BusinessStanding + "',");
builder.Append("'" + model.CraftworkEquip + "',");
builder.Append("'" + model.ProductQuality + "',");
builder.Append("'" + model.ManufacturingCapacity + "',");
builder.Append("'" + model.Equip + "',");
builder.Append("'" + model.Manpower + "',");
builder.Append("'" + model.OutstandingAchievement + "',");
builder.Append("'" + model.ServiceEnsure + "',");
builder.Append("'" + model.MarketingStrategy + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public ProviderInfoModel GetModel(int ProviderId)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from pm_provider_info ");
builder.Append(" where ProviderId=" + ProviderId);
ProviderInfoModel model = new ProviderInfoModel();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
model.ProviderId = ProviderId;
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["ClassId"].ToString() != "")
{
model.ClassId = int.Parse(set.Tables[0].Rows[0]["ClassId"].ToString());
}
model.ProviderName = set.Tables[0].Rows[0]["ProviderName"].ToString();
model.ProviderICode = set.Tables[0].Rows[0]["ProviderICode"].ToString();
if (set.Tables[0].Rows[0]["State"].ToString() != "")
{
model.State = set.Tables[0].Rows[0]["State"].ToString().Trim();
}
model.ServiceArea = set.Tables[0].Rows[0]["ServiceArea"].ToString();
model.Address = set.Tables[0].Rows[0]["Address"].ToString();
model.Contacter = set.Tables[0].Rows[0]["Contacter"].ToString();
model.Telphon = set.Tables[0].Rows[0]["Telphon"].ToString();
model.Mobile = set.Tables[0].Rows[0]["Mobile"].ToString();
model.WebStie = set.Tables[0].Rows[0]["WebStie"].ToString();
model.Email = set.Tables[0].Rows[0]["E-mail"].ToString();
model.PriceRange = set.Tables[0].Rows[0]["PriceRange"].ToString();
if (set.Tables[0].Rows[0]["Score"].ToString() != "")
{
model.Score = decimal.Parse(set.Tables[0].Rows[0]["Score"].ToString());
}
model.UserName = set.Tables[0].Rows[0]["UserName"].ToString();
model.PassWord = set.Tables[0].Rows[0]["PassWord"].ToString();
model.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["LastLoginTime"].ToString() != "")
{
model.LastLoginTime = DateTime.Parse(set.Tables[0].Rows[0]["LastLoginTime"].ToString());
}
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
model.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
model.Comment = set.Tables[0].Rows[0]["Comment"].ToString();
return(model);
}
public int Update(ProviderInfoModel model, string flag)
{
string str = FormsAuthentication.HashPasswordForStoringInConfigFile(this.SysPwd, "md5");
StringBuilder builder = new StringBuilder();
builder.Append("update pm_provider_info set ");
builder.Append("ProviderName=" + SqlStringConstructor.GetQuotedString(model.ProviderName.Trim()) + ",");
builder.Append("ProviderICode=" + SqlStringConstructor.GetQuotedString(model.ProviderICode.Trim()) + ",");
builder.Append("ClassId=" + model.ClassId.ToString() + ",");
builder.Append("ServiceArea=" + SqlStringConstructor.GetQuotedString(model.ServiceArea.Trim()) + ",");
builder.Append("Address=" + SqlStringConstructor.GetQuotedString(model.Address.Trim()) + ",");
builder.Append("Contacter=" + SqlStringConstructor.GetQuotedString(model.Contacter.Trim()) + ",");
builder.Append("Telphon=" + SqlStringConstructor.GetQuotedString(model.Telphon.Trim()) + ",");
builder.Append("Mobile=" + SqlStringConstructor.GetQuotedString(model.Mobile.Trim()) + ",");
builder.Append("WebStie=" + SqlStringConstructor.GetQuotedString(model.WebStie.Trim()) + ",");
builder.Append("[E-mail]=" + SqlStringConstructor.GetQuotedString(model.Email.Trim()) + ",");
builder.Append("PriceRange=" + SqlStringConstructor.GetQuotedString(model.PriceRange.Trim()) + ",");
builder.Append("ProduceDimensions='" + model.ProduceDimensions + "',");
builder.Append("TradeStatus='" + model.TradeStatus + "',");
builder.Append("MarketDispositionf='" + model.MarketDispositionf + "',");
builder.Append("BusinessStanding='" + model.BusinessStanding + "',");
builder.Append("CraftworkEquip='" + model.CraftworkEquip + "',");
builder.Append("ProductQuality='" + model.ProductQuality + "',");
builder.Append("ManufacturingCapacity='" + model.ManufacturingCapacity + "',");
builder.Append("Equip='" + model.Equip + "',");
builder.Append("Manpower='" + model.Manpower + "',");
builder.Append("OutstandingAchievement='" + model.OutstandingAchievement + "',");
builder.Append("ServiceEnsure='" + model.ServiceEnsure + "',");
builder.Append("MarketingStrategy='" + model.MarketingStrategy + "',");
builder.Append("Comment=" + SqlStringConstructor.GetQuotedString(model.Comment.Trim()) + ",");
if (flag == "y")
{
builder.Append("UserName="******",");
builder.Append("PassWord='******' ");
}
else
{
builder.Append("UserName="******" where ProviderId=" + model.ProviderId.ToString());
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
private ProviderModel GetRequestProvider()
{
ProviderModel oreturn = new ProviderModel();
oreturn.ProviderPublicId = Request["ProviderPublicIdEdit"];
oreturn.Name = Request["RazonSocial"];
oreturn.IdentificationType = new CatalogModel();
oreturn.IdentificationType.ItemId = int.Parse(Request["TipoIdentificacion"]);
oreturn.IdentificationNumber = Request["NumeroIdentificacion"];
oreturn.Email = Request["Email"];
oreturn.CustomerPublicId = Request["ProviderCustomerIdEdit"];
oreturn.RelatedProviderCustomerInfo = new List <ProviderInfoModel>();
ProviderInfoModel infoCheck = new ProviderInfoModel();
infoCheck.ProviderInfoType = new CatalogModel();
infoCheck.ProviderInfoType.ItemId = 378;
infoCheck.ProviderInfoId = int.Parse(Request["checkDigitInfoIdEdit"]);
infoCheck.Value = Request["checkDigit"];
oreturn.RelatedProviderCustomerInfo.Add(infoCheck);
return(oreturn);
}
private string ProccessProviderFile(string FilePath, string ErrorFilePath, string CustomerPublicId)
{
//get excel rows
LinqToExcel.ExcelQueryFactory XlsInfo = new LinqToExcel.ExcelQueryFactory(FilePath);
List <ExcelProviderModel> oPrvToProcess =
(from x in XlsInfo.Worksheet <ExcelProviderModel>(0)
select x).ToList();
List <ExcelProviderResultModel> oPrvToProcessResult = new List <ExcelProviderResultModel>();
//process Provider
oPrvToProcess.Where(prv => !string.IsNullOrEmpty(prv.NumeroIdentificacion)).All(prv =>
{
try
{
#region Operation
//Validar el provider
ProviderModel Provider = new ProviderModel();
ProviderModel oResultValidate = new ProviderModel();
ProviderModel oInfoValidate = new ProviderModel();
oResultValidate = DocumentManagement.Provider.Controller.Provider.ProviderGetByIdentification(prv.NumeroIdentificacion, Convert.ToInt32(prv.TipoIdentificacion), CustomerPublicId);
//Create ProviderCustomerInfo
List <ProviderInfoModel> ListCustomerProviderInfo = new List <ProviderInfoModel>();
ProviderInfoModel CustomerProviderInfo = new ProviderInfoModel();
if (oResultValidate == null)
{
CustomerProviderInfo.ProviderInfoType = new CatalogModel()
{
ItemId = 401
};
CustomerProviderInfo.Value = "201";
ListCustomerProviderInfo.Add(CustomerProviderInfo);
}
CustomerProviderInfo = new ProviderInfoModel();
CustomerProviderInfo.ProviderInfoId = oResultValidate != null ?
oResultValidate.RelatedProviderCustomerInfo.Where(x => x.ProviderInfoType.ItemId == 378).
Select(x => x.ProviderInfoId).FirstOrDefault() : 0;
CustomerProviderInfo.ProviderInfoType = new CatalogModel()
{
ItemId = 378
};
CustomerProviderInfo.Value = prv.DigitoVerificacion;
ListCustomerProviderInfo.Add(CustomerProviderInfo);
//Create Provider
ProviderModel ProviderToCreate = new ProviderModel()
{
CustomerPublicId = CustomerPublicId,
Name = prv.RazonSocial,
IdentificationType = new Provider.Models.Util.CatalogModel()
{
ItemId = Convert.ToInt32(prv.TipoIdentificacion)
},
IdentificationNumber = prv.NumeroIdentificacion,
Email = prv.Email,
RelatedProviderCustomerInfo = ListCustomerProviderInfo
};
if (oResultValidate == null)
{
DocumentManagement.Provider.Controller.Provider.ProviderUpsert(ProviderToCreate);
ProviderToCreate.CustomerPublicId = DocumentManagement.Models.General.InternalSettings.Instance[DocumentManagement.Models.General.Constants.C_Settings_PublicId_Publicar].Value;
ListCustomerProviderInfo.All(x =>
{
x.ProviderInfoId = 0;
return(true);
});
DocumentManagement.Provider.Controller.Provider.ProviderCustomerInfoUpsert(ProviderToCreate);
}
else
{
ProviderToCreate.ProviderPublicId = oResultValidate.ProviderPublicId;
DocumentManagement.Provider.Controller.Provider.ProviderCustomerInfoUpsert(ProviderToCreate);
}
oPrvToProcessResult.Add(new ExcelProviderResultModel()
{
PrvModel = prv,
Success = true,
Error = "Se ha creado el Proveedor '" + ProviderToCreate.ProviderPublicId + "'",
});
#endregion
}
catch (Exception err)
{
oPrvToProcessResult.Add(new ExcelProviderResultModel()
{
PrvModel = prv,
Success = false,
Error = "Error :: " + err.Message + " :: " +
err.StackTrace +
(err.InnerException == null ? string.Empty :
" :: " + err.InnerException.Message + " :: " +
err.InnerException.StackTrace),
});
}
return(true);
});
//save log file
#region Error log file
try
{
using (System.IO.StreamWriter sw = new System.IO.StreamWriter(ErrorFilePath))
{
string strSep = ";";
sw.WriteLine
("\"RazonSocial\"" + strSep +
"\"TipoIdentificacion\"" + strSep +
"\"NumeroIdentificaion\"" + strSep +
"\"DigitoVerificacion\"" + strSep +
"\"Email\"" + strSep +
"\"CampanaSalesforce\"" + strSep +
"\"PublicIdPublicar\"" + DocumentManagement.Models.General.Constants.C_Settings_PublicId_Publicar.ToString() +
"\"Success\"" + strSep +
"\"Error\"");
oPrvToProcessResult.All(lg =>
{
sw.WriteLine
("\"" + lg.PrvModel.RazonSocial + "\"" + strSep +
"\"" + lg.PrvModel.TipoIdentificacion + "\"" + strSep +
"\"" + lg.PrvModel.NumeroIdentificacion + "\"" + strSep +
"\"" + lg.PrvModel.DigitoVerificacion + "\"" + strSep +
"\"" + lg.PrvModel.Email + "\"" + strSep +
"\"" + lg.PrvModel.CampanaSalesforce + "\"" + strSep +
"\"" + lg.Success + "\"" + strSep +
"\"" + lg.Error + "\"");
return(true);
});
sw.Flush();
sw.Close();
}
//load file to s3
string strRemoteFile = ProveedoresOnLine.FileManager.FileController.LoadFile
(ErrorFilePath,
DocumentManagement.Models.General.InternalSettings.Instance[DocumentManagement.Models.General.Constants.C_Settings_File_ExcelDirectory].Value);
//remove temporal file
if (System.IO.File.Exists(ErrorFilePath))
{
System.IO.File.Delete(ErrorFilePath);
}
return(strRemoteFile);
}
catch { }
return(null);
#endregion
}
public virtual ActionResult UploadProvider(string CustomerPublicId, HttpPostedFileBase ExcelFile)
{
//eval upsert action
if (!string.IsNullOrEmpty(Request["UpsertAction"]) && Request["UpsertAction"].Trim() == "true")
{
try
{
string ProviderName = Request["ProviderName"].ToString();
string IdentificationNumber = Request["IdentificationNumber"].ToString();
string IdentificationType = Convert.ToInt32(Request["IdentificationType"]) == 0 ? string.Empty : Request["IdentificationType"];
string CheckDigit = string.IsNullOrEmpty(Request["CheckDigit"]) ? string.Empty : Request["CheckDigit"];
string Email = Request["Email"].ToString();
//string Salesforce = Request["Salesforce"].ToString();
#region Operation
//Validate provider
ProviderModel Provider = new ProviderModel();
ProviderModel oResultValidate = new ProviderModel();
ProviderModel oInfoValidate = new ProviderModel();
oResultValidate = DocumentManagement.Provider.Controller.Provider.ProviderGetByIdentification(IdentificationNumber, Convert.ToInt32(IdentificationType), CustomerPublicId);
//Create ProviderCustomerInfo
List <ProviderInfoModel> ListCustomerProviderInfo = new List <ProviderInfoModel>();
ProviderInfoModel CustomerProviderInfo = new ProviderInfoModel();
if (oResultValidate == null)
{
CustomerProviderInfo.ProviderInfoType = new CatalogModel()
{
ItemId = 401
};
CustomerProviderInfo.Value = "201";
ListCustomerProviderInfo.Add(CustomerProviderInfo);
}
CustomerProviderInfo = new ProviderInfoModel();
CustomerProviderInfo.ProviderInfoId = oResultValidate != null?
oResultValidate.RelatedProviderCustomerInfo.Where(x => x.ProviderInfoType.ItemId == 378).
Select(x => x.ProviderInfoId).FirstOrDefault() : 0;
CustomerProviderInfo.ProviderInfoType = new CatalogModel()
{
ItemId = 378
};
CustomerProviderInfo.Value = CheckDigit;
ListCustomerProviderInfo.Add(CustomerProviderInfo);
//Create Provider
ProviderModel ProviderToCreate = new ProviderModel()
{
CustomerPublicId = CustomerPublicId,
Name = ProviderName,
IdentificationType = new Provider.Models.Util.CatalogModel()
{
ItemId = Convert.ToInt32(IdentificationType)
},
IdentificationNumber = IdentificationNumber,
Email = Email,
RelatedProviderCustomerInfo = ListCustomerProviderInfo
};
if (oResultValidate == null)
{
DocumentManagement.Provider.Controller.Provider.ProviderUpsert(ProviderToCreate);
ProviderToCreate.CustomerPublicId = DocumentManagement.Models.General.InternalSettings.Instance[DocumentManagement.Models.General.Constants.C_Settings_PublicId_Publicar].Value;
ListCustomerProviderInfo.All(x =>
{
x.ProviderInfoId = 0;
return(true);
});
DocumentManagement.Provider.Controller.Provider.ProviderCustomerInfoUpsert(ProviderToCreate);
}
else
{
ProviderToCreate.ProviderPublicId = oResultValidate.ProviderPublicId;
DocumentManagement.Provider.Controller.Provider.ProviderCustomerInfoUpsert(ProviderToCreate);
}
#endregion
}
catch (Exception e)
{ }
}
if (ExcelFile != null)
{
string strFolder = Server.MapPath(DocumentManagement.Models.General.Constants.C_Settings_File_TempDirectory);
if (!System.IO.Directory.Exists(strFolder))
{
System.IO.Directory.CreateDirectory(strFolder);
}
//get File
string strFile = strFolder.TrimEnd('\\') +
"\\ProviderUploadFile_" +
CustomerPublicId + "_" +
DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
string ErrorFilePath = strFile.Replace(".xls", "_log.csv");
ExcelFile.SaveAs(strFile);
//load file to s3
string strRemoteFile = ProveedoresOnLine.FileManager.FileController.LoadFile
(strFile,
DocumentManagement.Models.General.InternalSettings.Instance[DocumentManagement.Models.General.Constants.C_Settings_File_ExcelDirectory].Value);
//update file into db
string logFile = this.ProccessProviderFile(strFile, ErrorFilePath, CustomerPublicId);
//remove temporal file
if (System.IO.File.Exists(strFile))
{
System.IO.File.Delete(strFile);
}
//ViewData.Add(strRemoteFile);
List <string> urlList = new List <string>();
urlList.Add(strRemoteFile);
urlList.Add(logFile);
ViewData["UrlReturn"] = urlList;
UpserCustomerModel oModel = new UpserCustomerModel()
{
RelatedCustomer = DocumentManagement.Customer.Controller.Customer.CustomerGetById(CustomerPublicId),
};
return(View(oModel));
}
else
{
UpserCustomerModel oModel = new UpserCustomerModel()
{
RelatedCustomer = DocumentManagement.Customer.Controller.Customer.CustomerGetById(CustomerPublicId),
};
return(View(oModel));
}
}
public virtual ActionResult DownloadFile()
{
ProviderSearchModel oReturn = new ProviderSearchModel();
int oTotalRows;
List <DocumentManagement.Provider.Models.Provider.ProviderModel> oProviderlst = DocumentManagement.Provider.Controller.Provider.ProviderSearch
(Request["divGridProvider_txtSearch"] == "" ? null : Request["divGridProvider_txtSearch"]
, Request["CustomerName"] == "" ? null : Request["CustomerName"]
, Request["FormId"] == "" ? null : Request["FormId"]
, 0, 65000, out oTotalRows,
Convert.ToBoolean(Request["chk_Unique"]));
oReturn.RelatedProvider = new List <ProviderItemSearchModel>();
oProviderlst.All(prv =>
{
oReturn.RelatedProvider.Add(new ProviderItemSearchModel()
{
RelatedProvider = prv,
});
return(true);
});
string strSep = ";";
StringBuilder data = new StringBuilder();
foreach (var item in oProviderlst)
{
string Campana = "";
ProviderInfoModel info = item.RelatedProviderCustomerInfo.Where(x => x.ProviderInfoType.ItemId == 403).Select(x => x).FirstOrDefault() == null ? null : item.RelatedProviderCustomerInfo.Where(x => x.ProviderInfoType.ItemId == 403).Select(x => x).FirstOrDefault();
if (info != null && info.ProviderInfoType.ItemId == 403)
{
Campana = info.Value;
}
else
{
Campana = "N/A";
}
if (oProviderlst.IndexOf(item) == 0)
{
data.AppendLine
("\"" + "RAZON SOCIAL" + "\"" + strSep +
"\"" + "TIPO IDENTIFICACION" + "\"" + strSep +
"\"" + "NUMERO IDENTIFICACION" + "\"" + strSep +
"\"" + "EMAIL" + "\"" + strSep +
"\"" + "CAMPANA" + "\"" + strSep +
"\"" + "URL" + "\"" + strSep +
"\"" + "FECHA MODIFICACION" + "\"" + strSep +
"\"" + "USUARIO ULTIMA MODIFICACION" + "\"");
data.AppendLine
("\"" + item.Name + "\"" + "" + strSep +
"\"" + item.IdentificationType.ItemName + "\"" + strSep +
"\"" + item.IdentificationNumber + "\"" + strSep +
"\"" + item.Email + "\"" + strSep +
"\"" + Campana + "\"" + strSep +
"\"" + Url.Action(MVC.ProviderForm.ActionNames.Index,
MVC.ProviderForm.Name,
new
{
ProviderPublicId = item.ProviderPublicId,
FormPublicId = item.FormPublicId
}) + "\"" + strSep +
"\"" + item.LogCreateDate + "\"" + strSep +
"\"" + item.LogUser + "\"");
}
else
{
data.AppendLine
("\"" + item.Name + "\"" + "" + strSep +
"\"" + item.IdentificationType.ItemName + "\"" + strSep +
"\"" + item.IdentificationNumber + "\"" + strSep +
"\"" + item.Email + "\"" + strSep +
"\"" + Campana + "\"" + strSep +
"\"" + Url.Action(MVC.ProviderForm.ActionNames.Index,
MVC.ProviderForm.Name,
new
{
ProviderPublicId = item.ProviderPublicId,
FormPublicId = item.FormPublicId
}) + "\"" + strSep +
"\"" + item.LogCreateDate + "\"" + strSep +
"\"" + item.LogUser + "\"");
}
}
byte[] buffer = Encoding.ASCII.GetBytes(data.ToString().ToCharArray());
return(File(buffer, "application/csv", "Proveedores_" + DateTime.Now.ToString("yyyyMMddHHmm") + ".csv"));
}
public static DataTable GetProviderSelect(ProviderInfoModel ProviderInfoM)
{
return(ProviderInfoDBHelper.GetProviderSelect(ProviderInfoM));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
ProviderInfoModel provider = new ProviderInfoModel();
provider.Address = txtAddress.Text.Trim();
provider.BankAddress = txtBankAddress.Text.Trim();
provider.BankName = ddlBankName.SelectedValue;
provider.BankNumber = txtBankNumber.Text.Trim();
provider.ID = Convert.ToInt32(ViewState["id"]);
provider.DutyNumber = txtDutyNumber.Text.Trim();
provider.Email = txtEmail.Text.Trim();
provider.Fax = txtFax.Text.Trim();
provider.ForShort = txtForShort.Text.Trim();
provider.LinkMan = txtLinkMan.Text.Trim();
provider.Mobile = txtMobile.Text.Trim();
provider.Name = txtName.Text.Trim();
provider.Number = lblNumber.Text.Trim();
provider.Remark = txtRemark.Text.Trim();
provider.Telephone = txtTelephone.Text.Trim();
provider.Url = txtUrl.Text.Trim();
provider.OperateIP = Request.UserHostAddress;
provider.OperateNum = CommonDataBLL.OperateBh;
provider.Status = 1;
provider.PermissionMan = "";
int providerNameIsExist = ProviderManageBLL.ProviderNameIsExist(provider.ID, provider.Name);
if (providerNameIsExist > 0)
{
this.msg = "<script language='javascript'>alert('" + GetTran("001170", "该供应商名称已被注册，请换一个供应商名称！") + "');</script>";
return;
}
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("ProviderInfo", "(ltrim(rtrim(id)))");
cl_h_info.AddRecord(Convert.ToInt32(provider.ID));
int updCount = ProviderManageBLL.UpdatePrivider(provider);
if (updCount > 0)
{
cl_h_info.AddRecord(Convert.ToInt32(provider.ID)); //不能放到事务中 修改数据后
cl_h_info.ModifiedIntoLogs(BLL.CommonClass.ChangeCategory.company6, Session["Company"].ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype4); //不能放到事务中
Page.ClientScript.RegisterStartupScript(GetType(), "", "<script language='javascript'>alert('" + GetTran("000222", "修改成功！") + "');location.href='Provider_ViewEdit.aspx'</script>");
}
else
{
ScriptHelper.SetAlert(this.Page, GetTran("001190", "修改失败，请检查你输入的信息！"));
}
}
//Add Provider
else
{
string number = DisposeString.DisString(txtnumber.Text.Trim());
if (ProviderManageBLL.GetProviderinfoNumber(number))
{
this.msg = "<script language='javascript'>alert('" + GetTran("001162", "该供应商编号已被注册，请换一个供应商编号！") + "');</script>";
return;
}
if (ProviderManageBLL.ProviderNameIsExist(txtName.Text.Trim()) > 0)
{
this.msg = "<script language='javascript'>alert('" + GetTran("001170", "该供应商名称已被注册，请换一个供应商名称！") + "');</script>";
return;
}
ProviderInfoModel provider = new ProviderInfoModel();
provider.Address = DisposeString.DisString(txtAddress.Text.Trim());
provider.BankAddress = DisposeString.DisString(txtBankAddress.Text.Trim());
provider.BankName = DisposeString.DisString(ddlBankName.SelectedValue);
provider.BankNumber = DisposeString.DisString(txtBankNumber.Text.Trim());
provider.DutyNumber = DisposeString.DisString(txtDutyNumber.Text.Trim());
provider.Email = DisposeString.DisString(txtEmail.Text.Trim());
provider.Fax = DisposeString.DisString(txtFax.Text.Trim());
provider.ForShort = DisposeString.DisString(txtForShort.Text.Trim());
provider.LinkMan = DisposeString.DisString(txtLinkMan.Text.Trim());
provider.Mobile = DisposeString.DisString(txtMobile.Text.Trim());
provider.Name = DisposeString.DisString(txtName.Text.Trim());
provider.Remark = DisposeString.DisString(txtRemark.Text.Trim());
provider.Telephone = DisposeString.DisString(txtTelephone.Text.Trim());
provider.Url = DisposeString.DisString(txtUrl.Text.Trim());
provider.OperateIP = Request.UserHostAddress;
provider.OperateNum = CommonDataBLL.OperateBh;
provider.Status = 1;
provider.Number = number;
provider.PermissionMan = "";
int addCount = ProviderManageBLL.AddPrivider(provider);
if (addCount > 0)
{
this.msg = "<script language='javascript'>alert('" + GetTran("001194", "保存成功！") + "');location.href='Provider_ViewEdit.aspx'</script>";
}
else
{
ScriptHelper.SetAlert(this.btnSave, GetTran("001177", "添加失败，请检查你输入的信息！"));
}
}
}
/// <summary>
/// Update the provider information by ID ---DS2012
/// 修改供应商信息
/// </summary>
/// <param name="provider">ProviderInfo model</param>
/// <returns>Return affected rows which update the provider information by ID</returns>
public static int UpdatePrivider(ProviderInfoModel provider)
{
return(ProviderInfoDAL.UpdateProviderInfo(provider));
}
/// <summary>
/// Add provider information ---DS2012
/// 添加供应商
/// </summary>
/// <param name="provider">ProviderInfo object</param>
/// <returns>Return affected rows which add provider information</returns>
public static int AddPrivider(ProviderInfoModel provider)
{
return(ProviderInfoDAL.AddProverderInfo(provider));
}
