/// <summary>
/// 添加客户资源
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public static int InsertCustomerRes(CustomerResModel model)
{
using (var dal = FactoryDispatcher.CustomerFactory())
{
return(dal.InsertCustomerRes(model));
}
}
/// <summary>
/// 添加客户资源
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public int InsertCustomerRes(CustomerResModel model)
{
string strSql = "insert into BM_CustomerRes (UserId,Name,Mobile,Addr,Remark,DataImg,SubmitName,Type) values(@UserId,@Name,@Mobile,@Addr,@Remark,@DataImg,@SubmitName,@Type);select @@IDENTITY;";
var param = new[] {
new SqlParameter("@UserId", model.UserId),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Mobile", model.Mobile),
new SqlParameter("@Addr", model.Addr),
new SqlParameter("@Remark", model.Remark),
new SqlParameter("@DataImg", model.DataImg),
new SqlParameter("@SubmitName", model.SubmitName),
new SqlParameter("@Type", model.Type)
};
object obj = DbHelperSQLP.ExecuteScalar(WebConfig.getConnectionString(), CommandType.Text, strSql, param);
if (obj != null)
{
return(Convert.ToInt32(obj));
}
return(0);
}
