111,098
社区成员




var sql = "insert MDG_Employee (MID, Gender, WorkType, IdCardNo, DirectLeader, OfficeAddress, HomeAddress, Photo, EntryDate, DimissionDate, Description, Status, LoginUser, CreatorDeptId, CreatorUserId) select @MID, @Gender, @WorkType, @IdCardNo, @DirectLeader, @OfficeAddress, @HomeAddress, @Photo, @EntryDate, @DimissionDate, @Description, @Status, @LoginUser, @CreatorDeptId, @CreatorUserId";
SqlParameter[] pam = { new SqlParameter("@MID", SqlDbType.UniqueIdentifier){ Value = d.MID },
new SqlParameter("@Gender", d.Gender),
new SqlParameter("@WorkType", SqlDbType.UniqueIdentifier){ Value = d.WorkType },
new SqlParameter("@IdCardNo", d.IdCardNo),
new SqlParameter("@DirectLeader", SqlDbType.UniqueIdentifier){ Value = d.DirectLeader },
new SqlParameter("@OfficeAddress", d.OfficeAddress),
new SqlParameter("@HomeAddress", d.HomeAddress),
new SqlParameter("@Photo", SqlDbType.Image){ Value = d.Photo},
new SqlParameter("@EntryDate", d.EntryDate),
new SqlParameter("@DimissionDate", d.DimissionDate),
new SqlParameter("@Description", d.Description),
new SqlParameter("@Status", d.Status),
new SqlParameter("@LoginUser", d.LoginUser),
new SqlParameter("@CreatorDeptId", SqlDbType.UniqueIdentifier){ Value = d.CreatorDeptId },
new SqlParameter("@CreatorUserId", SqlDbType.UniqueIdentifier){ Value = d.CreatorUserId },
new SqlParameter("@Read", SqlDbType.Int){ Value = 0 } };
这样的sql很难写吗???