public ContactWayEntity GetModel(ContactWayQuery query)
{
IContactWayService service = ServiceContainer.Instance.Container.Resolve <IContactWayService>();
ContactWayEntity model = service.GetContactWay(query.ContactID);
return(model);
}
public bool AddContactWay(ContactWayEntity contactWayEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("@JournalID");
sqlCommandText.Append(", @ChannelID");
sqlCommandText.Append(", @Company");
sqlCommandText.Append(", @LinkMan");
sqlCommandText.Append(", @Address");
sqlCommandText.Append(", @ZipCode");
sqlCommandText.Append(", @Tel");
sqlCommandText.Append(", @Fax");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.ContactWay ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, contactWayEntity.JournalID);
db.AddInParameter(cmd, "@ChannelID", DbType.Int64, contactWayEntity.ChannelID);
db.AddInParameter(cmd, "@Company", DbType.AnsiString, contactWayEntity.Company);
db.AddInParameter(cmd, "@LinkMan", DbType.AnsiString, contactWayEntity.LinkMan);
db.AddInParameter(cmd, "@Address", DbType.AnsiString, contactWayEntity.Address);
db.AddInParameter(cmd, "@ZipCode", DbType.AnsiString, contactWayEntity.ZipCode);
db.AddInParameter(cmd, "@Tel", DbType.AnsiString, contactWayEntity.Tel);
db.AddInParameter(cmd, "@Fax", DbType.AnsiString, contactWayEntity.Fax);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public ActionResult Save(ContactWayEntity model)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model.JournalID = CurAuthor.JournalID;
if (!string.IsNullOrWhiteSpace(model.Address))
{
model.Address = Server.UrlDecode(model.Address);
}
ExecResult result = service.SaveContactWay(model);
return(Json(new { result = result.result, msg = result.msg }));
}
public List <ContactWayEntity> MakeContactWayList(DataTable dt)
{
List <ContactWayEntity> list = new List <ContactWayEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ContactWayEntity contactWayEntity = MakeContactWay(dt.Rows[i]);
list.Add(contactWayEntity);
}
}
return(list);
}
private ContactWayEntity GetModel(Int64 ContactID)
{
ContactWayEntity model = null;
if (ContactID > 0)
{
ContactWayQuery query = new ContactWayQuery();
query.JournalID = CurAuthor.JournalID;
query.ContactID = ContactID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model = service.GetContactWayModel(query);
}
if (model == null)
{
model = new ContactWayEntity();
}
return(model);
}
public ContactWayEntity GetContactWay(Int64 contactID)
{
ContactWayEntity contactWayEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 ContactID,JournalID,ChannelID,Company,LinkMan,Address,ZipCode,Tel,Fax,AddDate FROM dbo.ContactWay WITH(NOLOCK)");
sqlCommandText.Append(" WHERE ContactID=@ContactID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@ContactID", DbType.Int64, contactID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
contactWayEntity = MakeContactWay(dr);
}
return(contactWayEntity);
}
public ContactWayEntity MakeContactWay(DataRow dr)
{
ContactWayEntity contactWayEntity = null;
if (dr != null)
{
contactWayEntity = new ContactWayEntity();
contactWayEntity.ContactID = (Int64)dr["ContactID"];
contactWayEntity.JournalID = (Int64)dr["JournalID"];
contactWayEntity.ChannelID = (Int64)dr["ChannelID"];
contactWayEntity.Company = (String)dr["Company"];
contactWayEntity.LinkMan = (String)dr["LinkMan"];
contactWayEntity.Address = (String)dr["Address"];
contactWayEntity.ZipCode = (String)dr["ZipCode"];
contactWayEntity.Tel = (String)dr["Tel"];
contactWayEntity.Fax = (String)dr["Fax"];
contactWayEntity.AddDate = (DateTime)dr["AddDate"];
}
return(contactWayEntity);
}
/// <summary>
/// 保存联系人
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult Save(ContactWayEntity model)
{
ExecResult execResult = new ExecResult();
bool result = false;
model.Company = model.Company.TextFilter();
model.LinkMan = model.LinkMan.TextFilter();
model.Tel = model.Tel.TextFilter();
model.Fax = model.Fax.TextFilter();
model.ZipCode = model.ZipCode.TextFilter();
model.Address = model.Address.TextFilter();
if (model.ContactID == 0)
{
result = AddContactWay(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增联系人信息成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增联系人信息失败！";
}
}
else
{
result = UpdateContactWay(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "修改联系人信息成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "修改联系人信息失败！";
}
}
return(execResult);
}
public List <ContactWayEntity> MakeContactWayList(IDataReader dr)
{
List <ContactWayEntity> list = new List <ContactWayEntity>();
while (dr.Read())
{
ContactWayEntity contactWayEntity = new ContactWayEntity();
contactWayEntity.ContactID = (Int64)dr["ContactID"];
contactWayEntity.JournalID = (Int64)dr["JournalID"];
contactWayEntity.ChannelID = (Int64)dr["ChannelID"];
contactWayEntity.Company = (String)dr["Company"];
contactWayEntity.LinkMan = (String)dr["LinkMan"];
contactWayEntity.Address = (String)dr["Address"];
contactWayEntity.ZipCode = (String)dr["ZipCode"];
contactWayEntity.Tel = (String)dr["Tel"];
contactWayEntity.Fax = (String)dr["Fax"];
contactWayEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(contactWayEntity);
}
dr.Close();
return(list);
}
public bool DeleteContactWay(ContactWayEntity contactWayEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("DELETE FROM dbo.ContactWay");
sqlCommandText.Append(" WHERE ContactID=@ContactID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@ContactID", DbType.Int64, contactWayEntity.ContactID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public bool UpdateContactWay(ContactWayEntity contactWayEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" ContactID=@ContactID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("Company=@Company");
sqlCommandText.Append(", LinkMan=@LinkMan");
sqlCommandText.Append(", Address=@Address");
sqlCommandText.Append(", ZipCode=@ZipCode");
sqlCommandText.Append(", Tel=@Tel");
sqlCommandText.Append(", Fax=@Fax");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.ContactWay SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@ContactID", DbType.Int64, contactWayEntity.ContactID);
db.AddInParameter(cmd, "@Company", DbType.AnsiString, contactWayEntity.Company);
db.AddInParameter(cmd, "@LinkMan", DbType.AnsiString, contactWayEntity.LinkMan);
db.AddInParameter(cmd, "@Address", DbType.AnsiString, contactWayEntity.Address);
db.AddInParameter(cmd, "@ZipCode", DbType.AnsiString, contactWayEntity.ZipCode);
db.AddInParameter(cmd, "@Tel", DbType.AnsiString, contactWayEntity.Tel);
db.AddInParameter(cmd, "@Fax", DbType.AnsiString, contactWayEntity.Fax);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="contactWay">ContactWayEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddContactWay(ContactWayEntity contactWay)
{
return(ContactWayDataAccess.Instance.AddContactWay(contactWay));
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="contactWay">ContactWayEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateContactWay(ContactWayEntity contactWay)
{
return(ContactWayBusProvider.UpdateContactWay(contactWay));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="contactWay">ContactWayEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddContactWay(ContactWayEntity contactWay)
{
return(ContactWayBusProvider.AddContactWay(contactWay));
}
public ExecResult Save(ContactWayEntity model)
{
IContactWayService service = ServiceContainer.Instance.Container.Resolve <IContactWayService>();
return(service.Save(model));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="contactWay">ContactWayEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteContactWay(ContactWayEntity contactWay)
{
return(ContactWayBusProvider.DeleteContactWay(contactWay));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="contactWay">ContactWayEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteContactWay(ContactWayEntity contactWay)
{
return(ContactWayDataAccess.Instance.DeleteContactWay(contactWay));
}
