/// <summary>
/// 样衣借出
/// </summary>
/// <param name="styleId"></param>
/// <param name="_user"></param>
/// <returns></returns>
public static bool DoLend(string styleId, User _user)
{
using (SunginDataContext sc = new SunginDataContext())
{
var style = sc.SampleBaseInfos.SingleOrDefault(p => p.StyleId == styleId);
LendRecord lr = sc.LendRecords.SingleOrDefault(p => p.StyleId == styleId && p.DdId == _user.DdId && (p.State != LendRecordStats.已还回));
if (style != null && lr == null)
{
lr = new LendRecord
{
StyleId = style.StyleId,
DdId = _user.DdId,
UserName = _user.UserName,
UserDept = _user.DepartName,
};
lr.SetCreateUser(_user.UserName);
sc.LendRecords.Add(lr);
}
else
{
return(false);
}
sc.SaveChanges();
}
return(true);
}
public int Add(LendRecord lendRecord)
{
var connectionString = this.GetConnection();
int count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "INSERT INTO LendRecord(IdLend, IdUser, IdBook, LendDate) VALUES (@IdLend, @IdUser, @IdBook, @LendDate); SELECT CAST(SCOPE_IDENTITY() as INT);";
count = con.Execute(query, lendRecord);
query = "UPDATE Book SET Amount = (Amount - 1) WHERE IdBook = " + lendRecord.IdBook;
count = con.Execute(query, lendRecord);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(count);
}
}
/// <summary>
/// 删除指定待借样衣
/// </summary>
/// <param name="styleId"></param>
/// <param name="user"></param>
/// <returns></returns>
public static bool DoDelete(int LendId, User _user)
{
using (SunginDataContext sc = new SunginDataContext())
{
LendRecord lr = sc.LendRecords.SingleOrDefault(p => p.Id == LendId);
if (lr != null)
{
sc.Entry(lr).State = System.Data.Entity.EntityState.Deleted;
}
else
{
return(false);
}
sc.SaveChanges();
}
return(true);
}
public int Edit(LendRecord lendRecord)
{
var connectionString = this.GetConnection();
var count = 0;
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "UPDATE LendRecord SET IdUser = @IdUser, IdBook = @IdBook, LendDate = @LendDate WHERE IdLend = " + lendRecord.IdLend;
count = con.Execute(query, lendRecord);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(count);
}
}
public LendRecord Get(int id)
{
var connectionString = this.GetConnection();
LendRecord lendRecord = new LendRecord();
using (var con = new SqlConnection(connectionString))
{
try
{
con.Open();
var query = "SELECT * FROM LendRecord WHERE IdLend =" + id;
lendRecord = con.Query <LendRecord>(query).FirstOrDefault();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
con.Close();
}
return(lendRecord);
}
}
public int Edit([FromBody] LendRecord lendRecord)
{
return(_lendRecordRepository.Edit(lendRecord));
}
public void Post([FromBody] LendRecord lendRecord)
{
_lendRecordRepository.Add(lendRecord);
}
