/// <summary>
/// 新增或者编辑一般客户
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public ActionResult ElectricityUserEdit(int ID = 0)
{
ElectricityUser model = new ElectricityUser();
if (ID != 0)
{
model = _iCrmService.GetPersonmodel(ID);
}
return(View(model));
}
/// <summary>
/// 一般客户
/// </summary>
/// <param name="strWhere"></param>
/// <param name="orderby"></param>
/// <param name="startIndex"></param>
/// <param name="endIndex"></param>
/// <returns></returns>
public List <ElectricityUser> GetListElectricityUser(string strWhere, string orderby, int startIndex, int endIndex, bool isAll = true)
{
DataTable dt = GetListByPageE(strWhere, orderby, startIndex, endIndex, isAll).Tables[0];
List <ElectricityUser> list = new List <ElectricityUser>();
if (dt != null && dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
ElectricityUser model = DataRowToModelE(dr);
list.Add(model);
}
}
return(list);
}
public ActionResult ElectricityUserEdit(ElectricityUser model)
{
string result = "失败";
model.isDel = 0;
model.lastOperateTime = DateTime.Now;
model.operatorTime = DateTime.Now;
int count = _iCrmService.AddPersonuser(model);
if (count > 0)
{
result = "成功";
}
ViewData["info"] = "" + (count > 0 ? "1" : "0") + "|" + result + "|ElectricityUserIndex|Edit";
return(View("SuccessScript"));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdatePersonuser(ElectricityUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_OrdinaryUsers set ");
strSql.Append("Name=@Name,");
strSql.Append("LinkPhone=@LinkPhone,");
strSql.Append("ElectricityConsumption=@ElectricityConsumption,");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("OperatorTime=@OperatorTime,");
strSql.Append("LastOperatorID=@LastOperatorID,");
strSql.Append("LastOperateTime=@LastOperateTime,");
strSql.Append("IsDel=@IsDel");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@LinkPhone", SqlDbType.VarChar, 50),
new SqlParameter("@ElectricityConsumption", SqlDbType.Float, 8),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@OperatorTime", SqlDbType.DateTime),
new SqlParameter("@LastOperatorID", SqlDbType.Int, 4),
new SqlParameter("@LastOperateTime", SqlDbType.DateTime),
new SqlParameter("@IsDel", SqlDbType.Int, 4),
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.linkPhone;
parameters[2].Value = model.electricityConsumption;
parameters[3].Value = model.operatorID;
parameters[4].Value = model.operatorTime;
parameters[5].Value = model.lastOperatorID;
parameters[6].Value = model.lastOperateTime;
parameters[7].Value = model.isDel;
parameters[8].Value = model.ID;
int rows = SQLHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ElectricityUser DataRowToModelE(DataRow row)
{
ElectricityUser model = new ElectricityUser();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Name"] != null)
{
model.name = row["Name"].ToString();
}
if (row["LinkPhone"] != null)
{
model.linkPhone = row["LinkPhone"].ToString();
}
if (row["ElectricityConsumption"] != null && row["ElectricityConsumption"].ToString() != "")
{
model.electricityConsumption = row["ElectricityConsumption"].ToString();
}
if (row["OperatorID"] != null && row["OperatorID"].ToString() != "")
{
model.operatorID = int.Parse(row["OperatorID"].ToString());
}
if (row["OperatorTime"] != null && row["OperatorTime"].ToString() != "")
{
model.operatorTime = DateTime.Parse(row["OperatorTime"].ToString());
}
if (row["LastOperatorID"] != null && row["LastOperatorID"].ToString() != "")
{
model.lastOperatorID = int.Parse(row["LastOperatorID"].ToString());
}
if (row["LastOperateTime"] != null && row["LastOperateTime"].ToString() != "")
{
model.lastOperateTime = DateTime.Parse(row["LastOperateTime"].ToString());
}
if (row["IsDel"] != null && row["IsDel"].ToString() != "")
{
model.isDel = int.Parse(row["IsDel"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddPersonuser(ElectricityUser model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_OrdinaryUsers(");
strSql.Append("Name,LinkPhone,ElectricityConsumption,OperatorID,OperatorTime,LastOperatorID,LastOperateTime,IsDel)");
strSql.Append(" values (");
strSql.Append("@Name,@LinkPhone,@ElectricityConsumption,@OperatorID,@OperatorTime,@LastOperatorID,@LastOperateTime,@IsDel)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.VarChar, 50),
new SqlParameter("@LinkPhone", SqlDbType.VarChar, 50),
new SqlParameter("@ElectricityConsumption", SqlDbType.Float, 8),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@OperatorTime", SqlDbType.DateTime),
new SqlParameter("@LastOperatorID", SqlDbType.Int, 4),
new SqlParameter("@LastOperateTime", SqlDbType.DateTime),
new SqlParameter("@IsDel", SqlDbType.Int, 4)
};
parameters[0].Value = model.name;
parameters[1].Value = model.linkPhone;
parameters[2].Value = model.electricityConsumption;
parameters[3].Value = model.operatorID;
parameters[4].Value = model.operatorTime;
parameters[5].Value = model.lastOperatorID;
parameters[6].Value = model.lastOperateTime;
parameters[7].Value = model.isDel;
object obj = SQLHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ElectricityUser GetPersonmodel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Name,LinkPhone,ElectricityConsumption,OperatorID,OperatorTime,LastOperatorID,LastOperateTime,IsDel from tb_OrdinaryUsers ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ElectricityUser model = new ElectricityUser();
DataSet ds = SQLHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModelE(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 新增一般用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddPersonuser(ElectricityUser model)
{
return(_iCrmRepository.AddPersonuser(model));
}
/// <summary>
/// 新增一般用户
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddPersonuser(ElectricityUser model)
{
return(_iCrmLogic.AddPersonuser(model));
}
