//修改
public int EnterpriseUpdate(Tz888.Model.Register.EnterpriseInfoModel model,
Tz888.Model.Register.OrgContactModel ContactModel,
List <Tz888.Model.Register.OrgContactMan> ContactManModels,
List <Tz888.Model.MemberResourceModel> infoResourceModels)
{
SqlParameter[] parameters =
{
#region 公司基本信息
new SqlParameter("@EnterpriseID", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@EnterpriseName", SqlDbType.VarChar, 200),
new SqlParameter("@ComAbout", SqlDbType.VarChar, -1),
new SqlParameter("@ComAboutBrief", SqlDbType.VarChar, -1),
new SqlParameter("@SetComTypeID", SqlDbType.Char, 10),
new SqlParameter("@Industrylist", SqlDbType.Char, 10),
new SqlParameter("@RegisterDate", SqlDbType.DateTime),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Char, 10),
new SqlParameter("@CityID", SqlDbType.Char, 10),
new SqlParameter("@CountyID", SqlDbType.Char, 10),
new SqlParameter("@currency", SqlDbType.Char, 10),
new SqlParameter("@RegCapital", SqlDbType.Float, 8),
new SqlParameter("@MainProduct", SqlDbType.VarChar, 30),
new SqlParameter("@RequirInfo", SqlDbType.Char, 30),
new SqlParameter("@AuditingStatus", SqlDbType.TinyInt, 1),
new SqlParameter("@ExhibitionHall", SqlDbType.VarChar, 100),
new SqlParameter("@hits", SqlDbType.VarChar, 100),
new SqlParameter("@remark", SqlDbType.VarChar, 100),
#endregion
#region 联系方式
new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100),
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Career", SqlDbType.VarChar, 20),
new SqlParameter("@TelCountryCode", SqlDbType.Char, 6),
new SqlParameter("@TelStateCode", SqlDbType.Char, 8),
new SqlParameter("@TelNum", SqlDbType.VarChar, 100),
new SqlParameter("@FaxCountryCode", SqlDbType.Char, 6),
new SqlParameter("@FaxStateCode", SqlDbType.Char, 8),
new SqlParameter("@FaxNum", SqlDbType.VarChar, 100),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 30),
new SqlParameter("@address", SqlDbType.VarChar, 100),
new SqlParameter("@PostCode", SqlDbType.VarChar, 10),
new SqlParameter("@Website", SqlDbType.VarChar, 200),
new SqlParameter("@IsDel", SqlDbType.Bit, 1),
new SqlParameter("@remark1", SqlDbType.VarChar, 100)
#endregion
};
parameters[0].Value = model.EnterpriseID;
parameters[1].Value = model.LoginName;
parameters[2].Value = model.EnterpriseName;
parameters[3].Value = model.ComAbout;
parameters[4].Value = model.ComAboutBrief;
parameters[5].Value = model.SetComTypeID;
parameters[6].Value = model.Industrylist;
parameters[7].Value = model.RegisterDate;
parameters[8].Value = model.CountryCode;
parameters[9].Value = model.ProvinceID;
parameters[10].Value = model.CityID;
parameters[11].Value = model.CountyID;
parameters[12].Value = model.currency;
parameters[13].Value = model.RegCapital;
parameters[14].Value = model.MainProduct;
parameters[15].Value = model.RequirInfo;
parameters[16].Value = model.AuditingStatus;
parameters[17].Value = model.ExhibitionHall;
parameters[18].Value = model.hits;
parameters[19].Value = model.remark;
parameters[20].Value = model.EnterpriseName;; //ContactModel.Name;
parameters[21].Value = ContactModel.Name;
parameters[22].Value = ContactModel.Career;
parameters[23].Value = ContactModel.TelCountryCode;
parameters[24].Value = ContactModel.TelStateCode;
parameters[25].Value = ContactModel.TelNum;
parameters[26].Value = ContactModel.FaxCountryCode;
parameters[27].Value = ContactModel.FaxStateCode;
parameters[28].Value = ContactModel.FaxNum;
parameters[29].Value = ContactModel.Email;
parameters[30].Value = ContactModel.Mobile;
parameters[31].Value = ContactModel.address;
parameters[32].Value = ContactModel.PostCode;
parameters[33].Value = ContactModel.Website;
parameters[34].Value = ContactModel.IsDel;
parameters[35].Value = ContactModel.remark;
int rowsAffected;
int EnterpriseID;
using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection())
{
sqlConn.Open();
SqlTransaction sqlTran = sqlConn.BeginTransaction();
try
{
//插入信息
DbHelperSQL.RunProcedure(sqlConn, sqlTran, "UP_EnterpriseTab_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
EnterpriseID = (int)parameters[0].Value;
}
else
{
EnterpriseID = 0;
}
Tz888.SQLServerDAL.Register.common obj2 = new common();
if (ContactManModels != null)
{
for (int i = 0; i < ContactManModels.Count; i++)
{
if (ContactManModels[i].Name != "" && ContactManModels[i].Name != null)
{
foreach (Tz888.Model.Register.OrgContactMan cm in ContactManModels)
{
// model.ContactID = ContactID;
if (!obj2.InsertContactMan(sqlConn, sqlTran, cm))
{
throw new Exception();
}
}
}
}
}
if (infoResourceModels != null)
{
//图片资源
Tz888.SQLServerDAL.MemberResourceDAL obj3 = new MemberResourceDAL();
foreach (Tz888.Model.MemberResourceModel modelRes in infoResourceModels)
{
modelRes.LoginName = model.LoginName;
int i = obj3.Add(sqlConn, sqlTran, modelRes);
}
}
sqlTran.Commit();
}
catch
{
sqlTran.Rollback();
EnterpriseID = -1;
}
finally
{
sqlConn.Close();
}
}
return(EnterpriseID);
}
//修改
public int GovernmentUpdate(Tz888.Model.Register.GovernmentInfoModel model,
Tz888.Model.Register.OrgContactModel ContactModel,
List <Tz888.Model.Register.OrgContactMan> ContactManModels,
List <Tz888.Model.MemberResourceModel> infoResourceModels)
{
SqlParameter[] parameters =
{
#region 基本信息
new SqlParameter("@GovernmentID", SqlDbType.Int, 4),
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@GovernmentName", SqlDbType.VarChar, 200),
new SqlParameter("@GovAbout", SqlDbType.VarChar, -1),
new SqlParameter("@GovAboutBrief", SqlDbType.VarChar, -1),
new SqlParameter("@SubjectType", SqlDbType.Char, 10),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Char, 10),
new SqlParameter("@CityID", SqlDbType.Char, 10),
new SqlParameter("@CountyID", SqlDbType.Char, 10),
new SqlParameter("@AuditingStatus", SqlDbType.TinyInt, 1),
new SqlParameter("@hits", SqlDbType.Int, 4),
new SqlParameter("@ExhibitionHall", SqlDbType.VarChar, 100),
new SqlParameter("@remark", SqlDbType.VarChar, 100),
#endregion
#region 联系方式
new SqlParameter("@OrganizationName", SqlDbType.VarChar, 100),
new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Career", SqlDbType.VarChar, 20),
new SqlParameter("@TelCountryCode", SqlDbType.Char, 3),
new SqlParameter("@TelStateCode", SqlDbType.Char, 4),
new SqlParameter("@TelNum", SqlDbType.VarChar, 60),
new SqlParameter("@FaxCountryCode", SqlDbType.Char, 3),
new SqlParameter("@FaxStateCode", SqlDbType.Char, 4),
new SqlParameter("@FaxNum", SqlDbType.VarChar, 60),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Mobile", SqlDbType.VarChar, 30),
new SqlParameter("@address", SqlDbType.VarChar, 100),
new SqlParameter("@PostCode", SqlDbType.VarChar, 10),
new SqlParameter("@Website", SqlDbType.VarChar, 200),
new SqlParameter("@IsDel", SqlDbType.Bit, 1),
new SqlParameter("@remark1", SqlDbType.VarChar, 100)
#endregion
};
parameters[0].Value = model.GovernmentID;
parameters[1].Value = model.LoginName;
parameters[2].Value = model.GovernmentName;
parameters[3].Value = model.GovAbout;
parameters[4].Value = model.GovAboutBrief;
parameters[5].Value = model.SubjectType;
parameters[6].Value = model.CountryCode;
parameters[7].Value = model.ProvinceID;
parameters[8].Value = model.CityID;
parameters[9].Value = model.CountyID;
parameters[10].Value = model.AuditingStatus;
parameters[11].Value = model.Hits;
parameters[12].Value = model.ExhibitionHall;
parameters[13].Value = model.remark;
parameters[14].Value = model.GovernmentName;
parameters[15].Value = ContactModel.Name;
parameters[16].Value = ContactModel.Career;
parameters[17].Value = ContactModel.TelCountryCode;
parameters[18].Value = ContactModel.TelStateCode;
parameters[19].Value = ContactModel.TelNum;
parameters[20].Value = ContactModel.FaxCountryCode;
parameters[21].Value = ContactModel.FaxStateCode;
parameters[22].Value = ContactModel.FaxNum;
parameters[23].Value = ContactModel.Email;
parameters[24].Value = ContactModel.Mobile;
parameters[25].Value = ContactModel.address;
parameters[26].Value = ContactModel.PostCode;
parameters[27].Value = ContactModel.Website;
parameters[28].Value = ContactModel.IsDel;
parameters[29].Value = ContactModel.remark;
int rowsAffected;
int GovernmentID;
using (SqlConnection sqlConn = DbHelperSQL.GetSqlConnection())
{
sqlConn.Open();
SqlTransaction sqlTran = sqlConn.BeginTransaction();
try
{
//插入信息
DbHelperSQL.RunProcedure(sqlConn, sqlTran, "UP_GovernmentTab_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
GovernmentID = (int)parameters[0].Value;
}
else
{
GovernmentID = 0;
}
//添加多个联系人(检查原联系人列表中是否己存在 LoginName = model.LoginName的联系人，
//如果己存就，将先删除全部后重新添加,obj2.InsertContactMan代码逻辑中)
Tz888.SQLServerDAL.Register.common obj2 = new common();
if (ContactManModels != null)
{
for (int i = 0; i < ContactManModels.Count; i++)
{
if (ContactManModels[i].Name != "" && ContactManModels[i].Name != null)
{
foreach (Tz888.Model.Register.OrgContactMan cm in ContactManModels)
{
if (!obj2.InsertContactMan(sqlConn, sqlTran, cm))
{
throw new Exception();
}
}
}
}
}
if (infoResourceModels != null)
{
//图片资源
Tz888.SQLServerDAL.MemberResourceDAL obj3 = new MemberResourceDAL();
foreach (Tz888.Model.MemberResourceModel modelRes in infoResourceModels)
{
modelRes.LoginName = model.LoginName;
int i = obj3.Add(sqlConn, sqlTran, modelRes);
}
}
sqlTran.Commit();
}
catch
{
sqlTran.Rollback();
GovernmentID = -1;
}
finally
{
sqlConn.Close();
}
}
return(GovernmentID);
}