/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_MachineDetail GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID, UserID,BuyMachineID, MachineNo, BuyTime, ActiveTime, IsActive, TransferTime, IsTransfer ");
strSql.Append(" from tb_MachineDetail ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.BigInt)
};
parameters[0].Value = ID;
lgk.Model.tb_MachineDetail model = new lgk.Model.tb_MachineDetail();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = long.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["BuyMachineID"].ToString() != "")
{
model.BuyMachineID = long.Parse(ds.Tables[0].Rows[0]["BuyMachineID"].ToString());
}
model.MachineNo = ds.Tables[0].Rows[0]["MachineNo"].ToString();
if (ds.Tables[0].Rows[0]["BuyTime"].ToString() != "")
{
model.BuyTime = DateTime.Parse(ds.Tables[0].Rows[0]["BuyTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ActiveTime"].ToString() != "")
{
model.ActiveTime = DateTime.Parse(ds.Tables[0].Rows[0]["ActiveTime"].ToString());
}
if (ds.Tables[0].Rows[0]["IsActive"].ToString() != "")
{
model.IsActive = int.Parse(ds.Tables[0].Rows[0]["IsActive"].ToString());
}
if (ds.Tables[0].Rows[0]["TransferTime"].ToString() != "")
{
model.TransferTime = DateTime.Parse(ds.Tables[0].Rows[0]["TransferTime"].ToString());
}
if (ds.Tables[0].Rows[0]["IsTransfer"].ToString() != "")
{
model.IsTransfer = int.Parse(ds.Tables[0].Rows[0]["IsTransfer"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_MachineDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_MachineDetail set ");
strSql.Append(" BuyMachineID = @BuyMachineID , ");
strSql.Append(" MachineNo = @MachineNo , ");
strSql.Append(" BuyTime = @BuyTime , ");
strSql.Append(" ActiveTime = @ActiveTime , ");
strSql.Append(" IsActive = @IsActive , ");
strSql.Append(" TransferTime = @TransferTime , ");
strSql.Append(" IsTransfer = @IsTransfer , ");
strSql.Append(" UserID = @UserID ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.BigInt,8) ,
new SqlParameter("@BuyMachineID", SqlDbType.BigInt,8) ,
new SqlParameter("@MachineNo", SqlDbType.VarChar,20) ,
new SqlParameter("@BuyTime", SqlDbType.DateTime) ,
new SqlParameter("@ActiveTime", SqlDbType.DateTime) ,
new SqlParameter("@IsActive", SqlDbType.Int,4) ,
new SqlParameter("@TransferTime", SqlDbType.DateTime) ,
new SqlParameter("@IsTransfer", SqlDbType.Int,4),
new SqlParameter("@UserID", SqlDbType.BigInt,8)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.BuyMachineID;
parameters[2].Value = model.MachineNo;
parameters[3].Value = model.BuyTime;
parameters[4].Value = model.ActiveTime;
parameters[5].Value = model.IsActive;
parameters[6].Value = model.TransferTime;
parameters[7].Value = model.IsTransfer;
parameters[8].Value = model.UserID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.tb_MachineDetail model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_MachineDetail(");
strSql.Append("BuyMachineID,MachineNo,BuyTime,ActiveTime,IsActive,TransferTime,IsTransfer,UserID");
strSql.Append(") values (");
strSql.Append("@BuyMachineID,@MachineNo,@BuyTime,@ActiveTime,@IsActive,@TransferTime,@IsTransfer,@UserID");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@BuyMachineID", SqlDbType.BigInt,8) ,
new SqlParameter("@MachineNo", SqlDbType.VarChar,20) ,
new SqlParameter("@BuyTime", SqlDbType.DateTime) ,
new SqlParameter("@ActiveTime", SqlDbType.DateTime) ,
new SqlParameter("@IsActive", SqlDbType.Int,4) ,
new SqlParameter("@TransferTime", SqlDbType.DateTime) ,
new SqlParameter("@IsTransfer", SqlDbType.Int,4),
new SqlParameter("@UserID", SqlDbType.BigInt,8)
};
parameters[0].Value = model.BuyMachineID;
parameters[1].Value = model.MachineNo;
parameters[2].Value = model.BuyTime;
parameters[3].Value = model.ActiveTime;
parameters[4].Value = model.IsActive;
parameters[5].Value = model.TransferTime;
parameters[6].Value = model.IsTransfer;
parameters[7].Value = model.UserID;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt64(obj);
}
}
//激活
public bool Active(long userid, long machineid, out string message)
{
message = "";
long ID = machineid;
lgk.Model.tb_MachineDetail machineModel = machineDetailBLL.GetModel(ID);
if (machineModel == null)
{
message = "该条记录不存在";
return(false);
}
lgk.Model.tb_user userModel = userBLL.GetModel(userid);
if (string.IsNullOrEmpty(userModel.IdenCode))
{
message = "需先验证身份证，才能激活矿机";
return(false);
}
if (machineModel.IsActive == 1)
{
message = "该记录已激活，无需再激活";
return(false);
}
if (machineModel.IsTransfer == 1)
{
message = "该记录已转让，不能激活";
return(false);
}
int result = machineDetailBLL.proc_MachineActive(machineModel.ID);
if (result == 2)
{
message = "激活成功";
return(true);
}
else
{
message = "激活失败";
return(false);
}
}
