public int Insert(PHA_BaseInfo obj)
{
using (Conn)
{
string query = @"INSERT INTO PHA_BaseInfo
VALUES(
@PhaCode,
@PhaName,
@CommonName,
@Spec,
@Unit,
@DosageForm,
@Repo,
@IsSpecial,
@DispenseWay,
@PinyinCode,
@WubiCode,
@IsAntibiotic,
@IsEmergency,
@IsValid,
@MinUnit,
@PharmacySpec,
@PharmacyUnit,
@PharmacyPack,
@MinPack,
@WardSpec,
@WardUnit,
@WardPack,
@PhaAttr,
@StorageCondition)";
return(Conn.Execute(query, obj));
}
}
public int Update(PHA_BaseInfo obj)
{
using (Conn)
{
string query = @"UPDATE PHA_BaseInfo SET
PhaName=@PhaName,
CommonName=@CommonName,
Spec=@Spec,
Unit=@Unit,
DosageForm=@DosageForm,
Repo=@Repo,
IsSpecial=@IsSpecial,
DispenseWay=@DispenseWay,
PinyinCode=@PinyinCode,
WubiCode=@WubiCode,
IsAntibiotic=@IsAntibiotic,
IsEmergency=@IsEmergency,
IsValid=@IsValid,
MinUnit=@MinUnit,
PharmacySpec=@PharmacySpec,
PharmacyUnit=@PharmacyUnit,
PharmacyPack=@PharmacyPack,
MinPack=@MinPack,
WardSpec=@WardSpec,
WardUnit=@WardUnit,
WardPack=@WardPack,
PhaAttr=@PhaAttr,
StorageCondition=@StorageCondition
WHERE PhaCode=@PhaCode";
return(Conn.Execute(query, obj));
}
}
public int Delete(PHA_BaseInfo obj)
{
using (Conn)
{
string query = @"DELETE FROM PHA_BaseInfo WHERE PhaCode=@PhaCode";
return(Conn.Execute(query, obj));
}
}
public void GetEntityTest()
{
//arrange
PHA_BaseInfo expected = new PHA_BaseInfo();
PHA_BaseInfo actual;
expected.PhaCode = "X000001";
//act
actual = dal.GetEntity("X000001");
//assert
Debug.WriteLine(actual);
Assert.AreEqual(expected.PhaCode, actual.PhaCode);
}
public ActionResult AcceptClick(PHA_BaseInfo obj)
{
string key = Request["key"];
int isOk = default(int);
//key表示是否编辑的标识，1表示处于编辑状态 0表示增加状态
if (key == "1")
{
isOk = ipha_baseinfobll.Update(obj);
}
else
{
PHA_BaseInfo temp = ipha_baseinfobll.GetEntity(obj.PhaCode);
if (temp == null)
{
isOk = ipha_baseinfobll.Insert(obj);
}
else
{
isOk = -1; //存在相同的记录，出错。
}
}
return(Content(isOk.ToString()));
}
public int Insert(PHA_BaseInfo obj)
{
return dal.Insert(obj);
}
public int Delete(PHA_BaseInfo obj)
{
return dal.Delete(obj);
}
public int Update(PHA_BaseInfo obj)
{
return dal.Update(obj);
}
