public SE_ShareMakeMoneyConfig GetEntity(int id)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Gungnir_AlwaysOnRead")))
{
string sql = "SELECT TOP 1 * FROM Configuration.dbo.SE_ShareMakeMoneyConfig (NOLOCK) where ID=@ID";
SE_ShareMakeMoneyConfig model = new SE_ShareMakeMoneyConfig();
return(dbHelper.ExecuteDataTable(sql, CommandType.Text, new SqlParameter()
{
ParameterName = "@ID",
Value = id
}).ConvertTo <SE_ShareMakeMoneyConfig>().FirstOrDefault());
}
}
public ActionResult Save(SE_ShareMakeMoneyConfig model)
{
ShareMakeMoneyManager manager = new ShareMakeMoneyManager();
if (manager.Save(model, User.Identity.Name))
{
return(Json(1));
}
else
{
return(Json(0));
}
}
public bool Save(SE_ShareMakeMoneyConfig model, string userName)
{
DALShareMakeMoneyConfig dal = new DALShareMakeMoneyConfig();
if (model.ID == 0)
{
model.CreateUserName = userName;
model.UpdateUserName = userName;
int id = 0;
return(dal.Add(model, out id));
}
else
{
model.UpdateUserName = userName;
return(dal.Update(model));
}
}
public bool Add(SE_ShareMakeMoneyConfig modelConfig, out int ID)
{
string sql = @"INSERT INTO Configuration.dbo.SE_ShareMakeMoneyConfig
(
Name ,
FirstShareNumber ,
RewardDateTime ,
CreateDate ,
UpdateDate ,
CreateUserName ,
UpdateUserName,
RuleInfo
)
VALUES (
@Name , -- Name - nvarchar(50)
@FirstShareNumber , -- FirstShareNumber - nvarchar(10)
@RewardDateTime , -- RewardDateTime - int
GETDATE() , -- CreateDate - datetime
@UpdateDate , -- UpdateDate - datetime
@CreateUserName , -- CreateUserName - nvarchar(50)
@UpdateUserName, -- UpdateUserName - nvarchar(50)
@RuleInfo
) SELECT @ResoutValue=@@IDENTITY ";
using (var db = DbHelper.CreateDefaultDbHelper())
{
SqlCommand cmd = new SqlCommand(sql);
cmd.Parameters.AddWithValue("@Name", modelConfig.Name);
cmd.Parameters.AddWithValue("@FirstShareNumber", modelConfig.FirstShareNumber);
cmd.Parameters.AddWithValue("@RewardDateTime", modelConfig.RewardDateTime);
cmd.Parameters.AddWithValue("@UpdateDate", DateTime.Now);
cmd.Parameters.AddWithValue("@CreateUserName", DateTime.Now);
cmd.Parameters.AddWithValue("@UpdateUserName", DateTime.Now);
cmd.Parameters.AddWithValue("@RuleInfo", modelConfig.RuleInfo);
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@ResoutValue",
Direction = ParameterDirection.Output,
SqlDbType = SqlDbType.Int
});
var result = db.ExecuteNonQuery(cmd) > 0;
ID = Convert.ToInt32(cmd.Parameters["@ResoutValue"].Value);
return(result);
}
}
public bool Update(SE_ShareMakeMoneyConfig model)
{
string sql = @"UPDATE Configuration.dbo.SE_ShareMakeMoneyConfig SET RuleInfo=@RuleInfo, Name=@Name, FirstShareNumber=@FirstShareNumber, RewardDateTime=@RewardDateTime, UpdateDate=@UpdateDate, UpdateUserName=@UpdateUserName WHERE ID=@ID ";
try
{
int i = DbHelper.ExecuteNonQuery(sql, CommandType.Text, new SqlParameter[] {
new SqlParameter("@Name", model.Name),
new SqlParameter("@FirstShareNumber", model.FirstShareNumber),
new SqlParameter("@RewardDateTime", model.RewardDateTime),
new SqlParameter("@UpdateDate", DateTime.Now),
new SqlParameter("@UpdateUserName", model.UpdateUserName),
new SqlParameter("@RuleInfo", model.RuleInfo),
new SqlParameter("@ID", model.ID)
});
return(i > 0);
}
catch (Exception em)
{
return(false);
}
}
